Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

suthashiniv
New Contributor

Hiding rows in pivot table

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

CategoriesQ1Q2
Category 1510
Category 2107
Category 358
Total2025

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

1 Solution

Accepted Solutions

Re: Hiding rows in pivot table

Hi,

Can you try this?

123.JPG

View solution in original post

5 Replies

Re: Hiding rows in pivot table

Here it is

Highlighted
aamertaimor
New Contributor III

Re: Hiding rows in pivot table

hi sutha,

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

suthashiniv
New Contributor

Re: Hiding rows in pivot table

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

Hi,

Can you try this?

123.JPG

View solution in original post

Not applicable

Re: Hiding rows in pivot table

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