Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

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
sunny_talwar

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

Capture.PNG

View solution in original post

5 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
sunny_talwar

Add this to your expression

+ Sum({1} 0)

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

Capture.PNG

newqlik2017
Creator II
Creator II
Author

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.

sunny_talwar

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

Capture.PNG

newqlik2017
Creator II
Creator II
Author

Thank you Sunny. And, Gysbert.