Is it possible to execute only part of a script ?

[#1]

Question might sound silly but I'm going to ask it anyways .

During reloading, is there a way by which we can make QlikView to only execute the code part that is selected/highlighted ? just to speed up the development.

Eg. in SQL Editors like Toad and SS-Management studio we can either execute all the content at once or a single statement. (I know these are not comparable, but that's the source of this idea)

So when there is new table added in existing document, we just have to execute the new code and QlikView accommodates it in the data-model.

[nagaiank · Accepted solution]

You can use

Exit Script

Command to stop execution at the line of your choice.

Alternatively, you can execute the script in debug mode and control / stop execution at any point.

[#3]

Hi Nagaian,

Both Exit script and debug mode will sequentially execute the script and stop at one point. So we only have partial data or transformations in the document.

I was hoping to execute a particular part of the code, without giving away already loaded data. This way one can iteratively write a complex transformation and see its effect quickly.

This is just a wishful thinking.

Thanks for your response !

[geert_gelade]

You can add a new table by using Partial Reload together with the "ADD LOAD" command.

In your script:

ExtraTable:

ADD LOAD * INLINE [

    F1, F2

    X, 1

    Y, 2

    Z, 3

];

If you use Partial reload now, it just loads the table "ExtraTable".