Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

routine in script

Hi,

What I want to achive it's a routine, as a function or procedure with parametres, in the script.

What for? Because of Incremental Load.

The code I have for incremental Load, goes before the table. So, if i have 20 tables i'd have to copy the mentioned code before each one. It'd be perfect to create a function and call it before each table giving it parametres, as the name of the table and others if necesary.

Is it possible to do this in the script??

thxs in advance.

1 Reply
pover
Partner - Master
Partner - Master

You can make a subroutine in the script like the following that is found the QlikView documentation:

// example 2 - parameter transfer
sub ParTrans (A,B,C)

A=A+1
B=B+1
C=C+1

end sub

A=1
X=1
C=1

call ParTrans (A,(X+1)*2)

In this case you might want to check out the for..each loop:

for each a in 1,3,7,'xyz'

load * from file$(a).csv

next

I hope that helps.