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

another tricky part ...


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?