Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
MVP & Luminary
MVP & Luminary

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

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
Highlighted
Specialist
Specialist

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

You can achieve this using

Partial Reload

Partial Reload Example

Highlighted
Contributor
Contributor

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

Not about load. go the line of the script 

Highlighted
MVP & Luminary
MVP & Luminary

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

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

Highlighted
Contributor
Contributor

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

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