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.
harleen_singh
Contributor III

Sum greater than 800 in pivot table

I have a following fields

RNo.   Month year   Quantity


I want to count only those RNo.'s in Pivot table who's sum greater than 800. I cannot apply dimension limits in Pivot Table

Any Idea how to achieve it?

thanks

Lavi

1 Solution

Accepted Solutions
MVP
MVP

Re: Sum greater than 800 in pivot table

Hi

You probably need something like this:

     Sum(Aggr(If(Sum(Quantity) > 800, 1), <dim1>, <dim2>, ...))

Where <dim1>, <dim2>, .... represent all the dimensions of your pivot table. The dimensions must be fields, not calculated dimensions.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
5 Replies
MVP
MVP

Re: Sum greater than 800 in pivot table

Hi,

Try like this

=Sum(If(Sum(Quantity) > 800, 1))

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Sum greater than 800 in pivot table

Hi

check this condition

use this condition in expression tab

if(sum(amount)>800,count(Rno))

harleen_singh
Contributor III

Re: Sum greater than 800 in pivot table

Hi arya,

               thanks but  it didn't worked perfectly in pivot table

ali_hijazi
Honored Contributor

Re: Sum greater than 800 in pivot table

As Arya is saying but check maybe you have to add an aggr to the sum(Amount) what is the dimension that you are using on your pivot table?

MVP
MVP

Re: Sum greater than 800 in pivot table

Hi

You probably need something like this:

     Sum(Aggr(If(Sum(Quantity) > 800, 1), <dim1>, <dim2>, ...))

Where <dim1>, <dim2>, .... represent all the dimensions of your pivot table. The dimensions must be fields, not calculated dimensions.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser