13 Replies Latest reply: May 8, 2012 10:58 PM by Nick Gan RSS

    another tricky part ...

    Nick Gan

      Hi fellow Qliksters...


      got one tricky table to build...


      Column FLAG_REF is what i'm building.


      Depending on column FLAG_ACT_FCST, if the value is ACTUAL, it will go M-1, M-2, M-3 in sequence.

      To do this, in the loading script, i'm using the Month value from the first column, and convert it to digit. easy !


      BUT, when the column value is FORECAST, i need it to start from F-1, F-2, F-3 in sequence, too.

      and the last count should be at the row of DEC.

      any idea for how the script should look like?