Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

loop in script


I have a file with script when I use many many times if function to compare dates and create a field.

I am creating fields called '01.2011', '01.2012' etc based on a function e.g.



(pst.date >= '06.02.2011', 'n/a', if(status = 'open' or [clearing date] > '06.02.2011' or (pst.date <= '31.12.2010' and [clearing date] > '06.02.2011'),'X','-')) as [01.2011],

Because i have such a line for every period from 2009-2012 I thought I could you maybe loop instead. However, I dont have idea how to do that.

I attached a file with sample of three lines of such code and also the two source files.

In tab v.3 I mapped all info from one table to another in case it is needed.

Does anyone how to replace the if lines with loop?

Thank you in advance


1 Reply
Valued Contributor

Re: loop in script


Have you checked if the dates you are using for comparison can't be obtained based on the current row you are reading for your table? Because loop structures in your script can increase the script execution time, so is best to avoid them...

Anyway, if you are right to choose this path you can use something like this:

FOR $(variable) = 0 to 1000


          if(field > $(variable), ...)



Community Browser