This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi, I have a pivot table with survey questions done by different category of users.
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
Can you try this?
View solution in original post
Here it is
Please see attached. I did this using calculated dimension. Is this you want?
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?
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