topic Expression for create each row 30 count total 12 row 360 count ? in QlikView

Expression for create each row 30 count total 12 row 360 count ?

paulyeo11 — Fri, 25 Dec 2015 12:56:04 GMT

Hi Sir

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 ?

Paul

sunny_talwar — Fri, 25 Dec 2015 13:14:15 GMT

Try this expression:

If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, If(Mod(RowNo(),12) = 0, 12, Mod(RowNo(),12)) * 30)

paulyeo11 — Fri, 25 Dec 2015 13:20:15 GMT

Hi Sunny

Many thank it work great.

Paul

paulyeo11 — Fri, 25 Dec 2015 13:55:32 GMT

Hi Sunny

Now i have another question :-