topic set analysis for else statement in QlikView https://community.qlik.com/t5/QlikView/set-analysis-for-else-statement/m-p/1202942#M387019 <HTML><HEAD></HEAD><BODY><P>Hi Qlik-ers,</P><P></P><P>I have a requirement where zero values need to be shown. When I use this expression count(distinct if(FieldA&gt;0, FieldA, 0)), the chart will show correctly. How do I force 0 in the else statement on set analysis ?</P><P></P><P>Any help is greatly appreciated. Thanks!</P></BODY></HTML> Tue, 01 Nov 2016 10:42:33 GMT 2016-11-01T10:42:33Z set analysis for else statement https://community.qlik.com/t5/QlikView/set-analysis-for-else-statement/m-p/1202942#M387019 <HTML><HEAD></HEAD><BODY><P>Hi Qlik-ers,</P><P></P><P>I have a requirement where zero values need to be shown. When I use this expression count(distinct if(FieldA&gt;0, FieldA, 0)), the chart will show correctly. How do I force 0 in the else statement on set analysis ?</P><P></P><P>Any help is greatly appreciated. Thanks!</P></BODY></HTML> Tue, 01 Nov 2016 10:42:33 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-else-statement/m-p/1202942#M387019 2016-11-01T10:42:33Z