Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

supress dimension where measure is zero

Hi guys new to Qlik Sense but loving it, I have been trying but for the life can not work out how to surpress a dimension on bar chart where the measure returns a zero value when suming the values in a field. Any pointers please

1 Solution

Accepted Solutions
sinanozdemir
Valued Contributor III

Re: supress dimension where measure is zero

It seems like there is a way easier option than what I originally suggested:

Just go to "Add-ons" section and "Data handling":

Capture.PNG

And un-check "Show zero values":

Capture2.PNG

Hope this one helps too.

If you think I have been able to answer your question, please mark the appropriate answer as correct answer.

Thank you.

5 Replies
sinanozdemir
Valued Contributor III

Re: supress dimension where measure is zero

Hi Stuart,

I will do my best to explain, please see the below screenshots:

As you can see in my Sum(Amount) column, I have zeroes:

Capture.PNG

Now, go to "Columns" on the right hand side and click on the first dimension. In my case I have two; Region and Company so I am clicking the first inner dimension. And then scroll down to "Limitation" part:

Capture2.PNG

From the "Limitation" drop down, choose "Exact value" and then ">", in the text box type "0".

And don't forget to un-check "Show others" box.

Capture3.PNG

Here is the end result:

Companies that had zeroes are suppressed.

Capture4.PNG

Hope this helps.

Not applicable

Re: supress dimension where measure is zero

First thanks for that Sinan,

I get that for tables but I am trying to do it in a chart

So for example lets say my data to load it as follows

So I put that into a simple table

How do i remove item 2 from the the chart without editing the data?

Can I use the expresion for the measure or the dimension to say something only the line only show title if sum of value is not equal to zero. If so what is the syntax

sinanozdemir
Valued Contributor III

Re: supress dimension where measure is zero

The same logic applies to charts as well:

Capture.PNG

sinanozdemir
Valued Contributor III

Re: supress dimension where measure is zero

Please see the attached example by using your data.

Thanks

sinanozdemir
Valued Contributor III

Re: supress dimension where measure is zero

It seems like there is a way easier option than what I originally suggested:

Just go to "Add-ons" section and "Data handling":

Capture.PNG

And un-check "Show zero values":

Capture2.PNG

Hope this one helps too.

If you think I have been able to answer your question, please mark the appropriate answer as correct answer.

Thank you.