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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lbrosten
Contributor III
Contributor III

Create a Master dimension which excludes all blank fields or zero in QlikSense.

How do I exclude from this bar chart any blank fields. This not a null value, but rather a blank.

I have the same question when you want to exclude from a chart if the value is zero.

lbrosten_0-1646697369577.png

 

Labels (2)
3 Replies
Lisa_Sun
Support
Support

For the master dimension, you can use the  expression to only show the data not equal to 0. 

Example:

=if(num(sales)<>0 ,num(sales))

Under the chart properties, uncheck "include null value" for the same dimension.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
lbrosten
Contributor III
Contributor III
Author

Lisa, thanks,  this is the expression I used but it threw and error this error      ')'expected

=if(Num[Severity Long Descr]<>0 ,Num[Severity Long Descr])

In this scenario the field is blank

 

Lisa_Sun
Support
Support

Hi @lbrosten ,

Could you please try this?  If it still does not work, can I have your sample qvf?

=if(Num(Severity Long Descr)<>0 ,Num(Severity Long Descr))

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!