Discussion Board for collaboration on QlikView Scripting.
Now i manually create a field in my row data DAY30 , which is not what i like :-
Row 1 30
Row 2 60
Row 3 90
Row 12 360
Then i use Sum(DAY30)to give the value i want.
May i know how to create this column using expression ? which give each row 30 for 12 row , total 12 row = 360.
meaning how to do it using expression , instead of manually enter at raw data ?
Go to Solution.
Try this expression:
If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, If(Mod(RowNo(),12) = 0, 12, Mod(RowNo(),12)) * 30)
Many thank it work great.
Now i have another question :-
How to make my Table 2 Display RATIO = 0.354 , Now it display 1.297