Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Can you let us know if it is possible in QlikView to loop through particular values in for loop in the script.
Eg: I want to write condition like this
a=x;
b=y;
c=z;
//Basically a, b, c are discrete values
for i= a to c;
..................
................
next
Hi
You can do this:
For Each zVar in ('a', 'b', 'c')
Let $(zVar) = 0;
Next
Hope that helps
Jonathan
Hi
You can do this:
For Each zVar in ('a', 'b', 'c')
Let $(zVar) = 0;
Next
Hope that helps
Jonathan
Hi
I'm not totally sure of how you wish to use this but you could use;
For each driver in a, b, c
Where driver is used in your script. So if you wanted to load one at a time for example, the script would be;
For each driver in a, b, c
Load
*
From [File} where $(driver);
I hope this helps, let me know how you get on.
Regards
Steve
Many Thanks Jonathan and Steve.
Answered exactly what I'm looking for.
I didn't know that for each loop exists in QlikView.
Regards,
Surendra