Qlik Community

Qlik Sense App Development

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

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

Tags (1)
1 Solution

Accepted Solutions
bellamae
Valued Contributor

Re: Do not want to show the else part in my chart

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

6 Replies
bellamae
Valued Contributor

Re: Do not want to show the else part in my chart

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

Not applicable

Re: Do not want to show the else part in my chart

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

Re: Do not want to show the else part in my chart

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

Re: Do not want to show the else part in my chart

Capture.PNG

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

Re: Do not want to show the else part in my chart

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

Re: Do not want to show the else part in my chart

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

Community Browser