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

    another tricky part ...

    nicksatch

      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?

       

      1502.jpg

       

       

      Thanks,