Script validation not only helps to validate the flow of the data but also help in finding the syntactical or variable evaluation errors from the script.

While creating the aggregated layer as per business logic, we sometimes use the variables to do calculations and in complex calculations we may also use the looping functions like for loop or do while loop. In such cases it becomes important to validate the script. Because if the script is not validated you may spend more time in validating the data later and then it becomes difficult to find the problems in scripting.

Qlik Sense provides the debug functionality through which you can run the code line by line and check many things like variable evaluations, record counts of the tables. The debug wizard also allows you to set the breakpoints so that while reloading in debug mode script stops for you to check the values and after your intervention it starts reloading script.

In Data Load Editor you will get the option to debug the script on right hand side. Button shown below will start a debug mode of the script.

Debug mode will open 3 tabs at the bottom of the screen those are

• Output: This will show you the script execution window
• Variable: This will show you variables along with the assigned values
• Breakpoint: This will show you the assigned breakpoints in script

Following figure shows the debug options:

Following figure shows you the options available in debug toolbar:

	This option is used to load only limited numbers of rows and help in reducing the time required for entire script execution.
	This option reloads the script automatically till the next breakpoint is reached. On breakpoint it will halt.
	This option helps in loading the script line by line.
	This will end the script execution.