9 Replies Latest reply: Dec 7, 2015 6:21 AM by Marcus Sommer RSS

    Nested If in For loop during Data Load

    Guohao Yee

      Hi All,


      I am trying to compute a YTD total sales during the data load in Qlik Sense.

      Basically, my idea is to use a For Loop to loop through the dates and if the conditions are right, i will sum up the sales figure.


      Below is a snapshot of my code. (Apologies, i don't know how to insert the code tag from Qlik Sense)


      But i got an error but i am not sure why.

      The error occurred in line 41:

      if 12/1/2012 <= 2012-11-01 00:00:00 then