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

[lbrosten]

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.

[Lisa_Sun]

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.

[lbrosten]

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]

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))