hiding rows from a pivot table

[ali_hijazi]

Hello I got a pivot table that shows the sales by country, brand, and branch

I want to hide rows where sales is less than $ 500

is this possible?

Please advise

[#2]

You can write it in the expression.  For example:

Sum({$<Sales={'>=500'}>} Sales)

[ali_hijazi]

No no

I meant to hide the sum(sales) not when the amount in the original table

[#4]

if(Sum(Sales)>=500,Sum(Sales)) then Suppress Nulls

[ali_hijazi]

sounds good but for complex expressions I have to risk performance

[#6]

Have you found an answer to hiding specific rows in a pivot table? I am trying to do the same thing. Thanks!

[johnw]

I'm not thinking of a better way than what was presented.  While I don't know this to be the case, I suspect that QlikView will be smart enough to realize it's already done the exact same summation, and just pull the result from the cache, rather than calculating the exact same thing twice.  If instead of sum(Sales) you have some huge expression, consider making a variable so that you don't have to work to keep the two parts of the expression in sync.