# 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.
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

## 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

## 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))

Contributor III

## Re: Sum greater than 800 in pivot table

Hi arya,

thanks but  it didn't worked perfectly in pivot table

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

## 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