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: 
aaronnayan
Creator III
Creator III

3 zeros i dont want to see it

Hi guys

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.

1 Solution

Accepted Solutions
atoz1158
Creator II
Creator II

Aaron

Try using a Calculated dimension along the lines of

=IF(E1+E2+E3<>0,1)

And then tick the box on the dimension to suppress Nulls

Regards

Adrian

View solution in original post

4 Replies
sunny_talwar

Can you share a snapshot of what you are seeing? May be check 'Suppress Zero Values' on Presentation tab of chart properties

aaronnayan
Creator III
Creator III
Author

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?

sunny_talwar

Sample with a mocked up data? If that is something you are unable to do, then I will let someone else help you

Best,

Sunny

atoz1158
Creator II
Creator II

Aaron

Try using a Calculated dimension along the lines of

=IF(E1+E2+E3<>0,1)

And then tick the box on the dimension to suppress Nulls

Regards

Adrian