Do not want to show the else part in my chart

[#1]

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'.

[Anonymous · Accepted solution]

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

[#3]

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

[#5]

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?

[#7]

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