Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do not want to show the else part in my chart

how do I do not show the else expression in my chart.

If(Match(&,'X1Y1',X2Y2','X1Y1''),'first', 'NONE').

In the expression above, I dont want to show the values which are not grouped under 'first'.

1 Solution

Accepted Solutions
bellamae
Specialist
Specialist

replace the 'NONE' with Null() and make sure your chart is not showing null values.

View solution in original post

6 Replies
bellamae
Specialist
Specialist

replace the 'NONE' with Null() and make sure your chart is not showing null values.

View solution in original post

Not applicable
Author

I already tried null() and  I see two columns  as "first" and "-" . I do not want the 2nd column "-"

sunny_talwar

Can you share a screenshot of where you trying to do this, and show us the final result you are seeing as well

Not applicable
Author

Capture.PNG

I highlighted the the two columns. I wanted the first column only.

sunny_talwar

Can you try to check 'Suppress When Value Is Null' on the dimension tab of the chart properties and see if that helps?

Not applicable
Author

in qlik sense, when i unchecked the "Show null value", it worked. Thank you