Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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

1 Solution

Accepted Solutions
sunny_talwar

Try this expression:

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

Capture.PNG

View solution in original post

3 Replies
sunny_talwar

Try this expression:

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

Capture.PNG

paulyeo11
Master
Master
Author

Hi Sunny

Many thank it work great.

Paul

paulyeo11
Master
Master
Author