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,