topic Re: Only show totals above a certain amount? in QlikView

Only show totals above a certain amount?

RJW — Mon, 14 Mar 2022 20:48:56 GMT

I have a pivot table in QlikView and would only like to show the information for Client ID's that have an amount in any of the expressions over 2,000.

In this case, I don't care about client 7564 and the one row for client 6633 and don't want them to be shown at all.

Re: Only show totals above a certain amount?

Or — Mon, 14 Mar 2022 22:32:26 GMT

You'd need something like:

If(Max(Aggr(Sum(Sales),[Client ID],[Date],[Sold Deal Date]))>2000,Sum(Sales))

I can't check this without sample data, which I am not able to generate at the moment and was not included in the post, but even if it's not precisely what you need it will hopefully nudge you in the right direction.