topic Re: hiding rows from a pivot table in QlikView

hiding rows from a pivot table

ali_hijazi — Mon, 08 Oct 2012 12:27:41 GMT

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

Re: hiding rows from a pivot table

Mon, 08 Oct 2012 13:11:45 GMT

You can write it in the expression. For example:

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

Re: hiding rows from a pivot table

ali_hijazi — Mon, 08 Oct 2012 13:41:00 GMT

No no

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

Re: hiding rows from a pivot table

Mon, 08 Oct 2012 13:49:56 GMT

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

Re: hiding rows from a pivot table

ali_hijazi — Mon, 08 Oct 2012 14:14:57 GMT

sounds good but for complex expressions I have to risk performance

Re: hiding rows from a pivot table

Fri, 12 Oct 2012 21:24:08 GMT

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

Re: hiding rows from a pivot table

johnw — Fri, 12 Oct 2012 22:17:48 GMT

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.