topic Re: Looping through specific values in QlikView

Looping through specific values

Tue, 01 Oct 2013 10:46:42 GMT

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;

..................

................

jonathandienst — Tue, 01 Oct 2013 10:52:37 GMT

You can do this:

For Each zVar in ('a', 'b', 'c')

Let $(zVar) = 0;

Hope that helps

Jonathan

Tue, 01 Oct 2013 10:55:15 GMT

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

Tue, 01 Oct 2013 11:20:26 GMT

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