topic Re: How to display all state values even if the value is 0 (zero) in QlikView https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95965#M762203 <HTML><HEAD></HEAD><BODY><P>Disable the Suppress Zero-Values options on the Presentation tab.</P></BODY></HTML> Wed, 01 Aug 2018 14:17:06 GMT Gysbert_Wassenaar 2018-08-01T14:17:06Z How to display all state values even if the value is 0 (zero) https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95964#M762202 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>Attached is the sample qvw for reference.</P><P></P><P>When 2010 is selected, OH state disappears.</P><P>When 2009 is selected, OH state appears. Need OH to be displayed no matter what year is selected.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209592_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95964#M762202 newqlik2017 2020-11-25T16:16:04Z Re: How to display all state values even if the value is 0 (zero) https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95965#M762203 <HTML><HEAD></HEAD><BODY><P>Disable the Suppress Zero-Values options on the Presentation tab.</P></BODY></HTML> Wed, 01 Aug 2018 14:17:06 GMT https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95965#M762203 Gysbert_Wassenaar 2018-08-01T14:17:06Z Re: How to display all state values even if the value is 0 (zero) https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95966#M762204 <HTML><HEAD></HEAD><BODY><P>Add this to your expression</P><P><STRONG>+ Sum({1} 0)</STRONG></P><P></P><P>and uncheck 'Suppress Zero Values' on the presentation tab of the chart properties</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209587_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 01 Aug 2018 14:18:37 GMT https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95966#M762204 sunny_talwar 2018-08-01T14:18:37Z Re: How to display all state values even if the value is 0 (zero) https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95967#M762205 <HTML><HEAD></HEAD><BODY><P>Oh, I forgot to mention there's a Type field with A and B values.</P><P>When Type A is selected OH disappears for 2009 but not for 2010.<BR />Can we display OH for both 2009 and 2010 even when Type A is selected.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209597_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 01 Aug 2018 14:38:06 GMT https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95967#M762205 newqlik2017 2018-08-01T14:38:06Z Re: How to display all state values even if the value is 0 (zero) https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95968#M762206 <HTML><HEAD></HEAD><BODY><P>Add&nbsp; + Sum({1} 0) to 2009 expression as well</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209601_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 01 Aug 2018 14:44:38 GMT https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95968#M762206 sunny_talwar 2018-08-01T14:44:38Z Re: How to display all state values even if the value is 0 (zero) https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95969#M762207 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny. And, Gysbert. </P></BODY></HTML> Wed, 01 Aug 2018 15:05:54 GMT https://community.qlik.com/t5/QlikView/How-to-display-all-state-values-even-if-the-value-is-0-zero/m-p/95969#M762207 newqlik2017 2018-08-01T15:05:54Z