Please enable JavaScript.
Coggle requires JavaScript to display documents.
Qlikview Script Statement (Control Statement Each clause of a control…
Qlikview Script Statement
Regular Statement
Control Statement
Each clause of a control statement must be kept inside one script line
Sub
Sub name [ ( paramlist )] statements end sub
Call
Call name ( [ paramlist ])
Do..Loop
Do [ ( while | until ) condition ] [statements]
[exit do [ ( when | unless ) condition ] [statements]
loop[ ( while | until ) condition ]
For..next
For counter = expr1 to expr2 [ step expr3 ] [statements] [exit for [ ( when | unless ) condition ] [statements] Next [counter]
For each..next
for each var in list [statements] [exit for [ ( when | unless ) condition ] [statements] next [var]
If...Then...Else...End
If condition then [ statements ] { elseif condition then [ statements ] } [ else [ statements ] ] end if
Switch..case..default..end switch
Switch expression {case valuelist [ statements ]} [default statements] end switch
Exit script
Exit Script [ (when | unless) condition ]
Prefixes
Prefixes in Detail
Add
Add [only] (loadstatement | selectstatement | mapstatement)
The add prefix can be added to any LOAD, SELECT or map...using statement in the script. It is only relevant during partial reloads.
Add Only Load...only run for additional load.
Add Load...run for both full and additional load
Load
Buffer
Buffer [(option [ , option])] ( loadstatement | selectstatement ) option::= incremental | stale [after] amount [(days | hours)]
QVD file will be created as buffer/cache
Buffer SELECT * from MyTable;
Example 2:
Buffer (stale after 7 days) SELECT * from MyTable;
Example 3:
Buffer (incremental) LOAD * from MyLog.log;
See also:
Buddle
Info