Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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
Partner

Here it is

aamertaimor
Contributor III
Contributor III

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

View solution in original post

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