Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sateesh_genre
Contributor II
Contributor II

How can I go to specific line of the code in Qlik Script

Hi All,

How can I go to specific line of the code in Qlik Script. Suppose If we have QVD generator which will create multiple qvd's with in QVW file in different tabs. So if we want to go to specific tab and execute the script from the there.I don't want to execute all the sheets.As I can not comment each tab and execute the script. 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

There is no direct "goto" in the Qlik Script language.  If you want to conditionally execute blocks of script, you have a few options.

1. Organize your script into one Load or major block per script tab. Demote/Promote the script tabs. Use a single tab with "Exit Script" to separate the tabs you want executed from the ones you don't. 

2. Wrap your script blocks with 
IF ... THEN 
ENDIF

You can then use variables or other conditionals to control what gets executed. 

3. Wrap your script blocks with SUB / ENDSUB.  Then have one tab at the end with a series of CALL statements that executes your blocks in the order you want. It's easy to rearrange, comment or wrap the CALL(s) with IF/ENDIF.

Sorry, no GoTo 🙂

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

4 Replies
vamsee
Specialist
Specialist

You can achieve this using

Partial Reload

Partial Reload Example

sateesh_genre
Contributor II
Contributor II
Author

Not about load. go the line of the script 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

There is no direct "goto" in the Qlik Script language.  If you want to conditionally execute blocks of script, you have a few options.

1. Organize your script into one Load or major block per script tab. Demote/Promote the script tabs. Use a single tab with "Exit Script" to separate the tabs you want executed from the ones you don't. 

2. Wrap your script blocks with 
IF ... THEN 
ENDIF

You can then use variables or other conditionals to control what gets executed. 

3. Wrap your script blocks with SUB / ENDSUB.  Then have one tab at the end with a series of CALL statements that executes your blocks in the order you want. It's easy to rearrange, comment or wrap the CALL(s) with IF/ENDIF.

Sorry, no GoTo 🙂

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

sateesh_genre
Contributor II
Contributor II
Author

Thanks for the clarification..Rob..:-)