Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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

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

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

3 Replies

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

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
Valued Contributor II

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

Hi Sunny

Many thank it work great.

Paul

paulyeo11
Valued Contributor II

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

Community Browser