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

      loop.png