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.
I have a small pivot chart
which consists of 4 columns
If the result for the row, for 3 of the columns is zero, i do not want to see the row.
Is it possible to do this in an expression?
where 0 <> null I.e.
Try using a Calculated dimension along the lines of
And then tick the box on the dimension to suppress Nulls
View solution in original post
Can you share a snapshot of what you are seeing? May be check 'Suppress Zero Values' on Presentation tab of chart properties
Sorry Sunny i cannot.
There are 3 expressions
If the value in the same row for all 3 expressions is zero
I do not want the user to see it. Do you think this is possible?
Sample with a mocked up data? If that is something you are unable to do, then I will let someone else help you