Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suthashiniv
Contributor
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
settu_periasamy
Master III
Master III

Hi,

Can you try this?

123.JPG

View solution in original post

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Here it is

Anonymous
Not applicable

hi sutha,

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

suthashiniv
Contributor
Contributor
Author

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?

settu_periasamy
Master III
Master III

Hi,

Can you try this?

123.JPG

Not applicable

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