topic Re: Hiding rows in pivot table in QlikView

Hiding rows in pivot table

suthashiniv — Wed, 15 Jul 2015 10:05:02 GMT

Hi, I have a pivot table with survey questions done by different category of users.

Categories	Q1	Q2
Category 1	5	10
Category 2	10	7
Category 3	5	8
Total	20	25

I want to hide category 3 but the total value should include the Q1 and Q2 values from Category 3. can this be done? please help

Re: Hiding rows in pivot table

alexandros17 — Wed, 15 Jul 2015 10:11:15 GMT

Here it is

Re: Hiding rows in pivot table

Anonymous — Wed, 15 Jul 2015 10:19:06 GMT

hi sutha,

Please see attached. I did this using calculated dimension. Is this you want?

Re: Hiding rows in pivot table

suthashiniv — Mon, 20 Jul 2015 02:35:24 GMT

Hi,

Thanks for the help. I have managed to hide the rows but the total is affected though i have followed the same method. the total excludes the hidden rows values. Is there any other way to prevent this?

Re: Hiding rows in pivot table

settu_periasamy — Mon, 20 Jul 2015 03:57:51 GMT

Hi,

Can you try this?

Re: Hiding rows in pivot table

Mon, 20 Jul 2015 05:45:16 GMT

If you did like that means there is no sense in business terms. 5 + 10 = 20 means its not a correct your approach is wrong