Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Re: Qlik Sense suppress zero/null values in Measure

Can you show an image of this?

amirmohamed
New Contributor III

Re: Qlik Sense suppress zero/null values in Measure

Hi Andrea,

Thank you very much for your help,

your comment put the answer to my head

I made sure all the other measures are equal to zero or null by

if(sum(sales) - sum(margin) <> 0, sum(measure1))

Employee
Employee

Re: Qlik Sense suppress zero/null values in Measure

In qlik sense you can just suppress null values in your visualizations - here is what that looks like in tables: 0General.png

Note that by default viewing nulls are turned on.