Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

newqlik2017
Contributor

How to display all state values even if the value is 0 (zero)

Hello, I have the below data set where OH has 0 value in 2010 but has 50 in 2009. How can we display all the states from the RAW DATA despite of the Amount value?

Attached is the sample qvw for reference.

When 2010 is selected, OH state disappears.

When 2009 is selected, OH state appears. Need OH to be displayed no matter what year is selected.

1 Solution

Accepted Solutions

Re: How to display all state values even if the value is 0 (zero)

Add  + Sum({1} 0) to 2009 expression as well

Capture.PNG

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

Re: How to display all state values even if the value is 0 (zero)

Disable the Suppress Zero-Values options on the Presentation tab.


talk is cheap, supply exceeds demand

Re: How to display all state values even if the value is 0 (zero)

Add this to your expression

+ Sum({1} 0)

and uncheck 'Suppress Zero Values' on the presentation tab of the chart properties

Capture.PNG

newqlik2017
Contributor

Re: How to display all state values even if the value is 0 (zero)

Oh, I forgot to mention there's a Type field with A and B values.

When Type A is selected OH disappears for 2009 but not for 2010.
Can we display OH for both 2009 and 2010 even when Type A is selected.

Re: How to display all state values even if the value is 0 (zero)

Add  + Sum({1} 0) to 2009 expression as well

Capture.PNG

View solution in original post

newqlik2017
Contributor

Re: How to display all state values even if the value is 0 (zero)

Thank you Sunny. And, Gysbert.