Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Disable the Suppress Zero-Values options on the Presentation tab.
Add this to your expression
+ Sum({1} 0)
and uncheck 'Suppress Zero Values' on the presentation tab of the chart properties
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.
Add + Sum({1} 0) to 2009 expression as well
Thank you Sunny. And, Gysbert.