Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Removing '-' from chart

Hello

I've got a problem with a pie chart.

My dimension code is: =IF(not(Field1 = 'string'), Field2)

Expression code is just sum of field: SUM(field)

Everything works fine, but there's a '-' value, which represents values of (Field1 = 'string') from dimension.

Is there any way to remove these values from this chart?

null.PNG

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Under dimension tab, tick suppress when value is null for this calculated dimension.

View solution in original post

1 Reply
MK_QSL
MVP
MVP

Under dimension tab, tick suppress when value is null for this calculated dimension.