topic Re: suppress zero values in Group in QlikView https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806565#M284754 <HTML><HEAD></HEAD><BODY><P>Senthil,</P><P>Try this as calculated dimension:</P><P></P><P>=if (not isnull([<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">location group]</SPAN>),[<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">location group]</SPAN>)</P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Tue, 11 Nov 2014 07:04:27 GMT amit_saini 2014-11-11T07:04:27Z suppress zero values in Group https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806560#M284749 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>I have one chart in this, am adding some dimension (for ex, used dmension is a location group) , in this group dimension return some values are zero, how toeliminate this zero, while displaying the chart.</P><P></P><P>Regards,</P><P>Senthil.K</P><P><IMG alt="zero.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70909_zero.png" style="width: 620px; height: 303px;" /></P></BODY></HTML> Tue, 11 Nov 2014 06:39:14 GMT https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806560#M284749 2014-11-11T06:39:14Z Re: suppress zero values in Group https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806561#M284750 <HTML><HEAD></HEAD><BODY><P>Could you please upload sample qvw?</P></BODY></HTML> Tue, 11 Nov 2014 06:45:13 GMT https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806561#M284750 senpradip007 2014-11-11T06:45:13Z Re: suppress zero values in Group https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806562#M284751 <HTML><HEAD></HEAD><BODY><P>Use calculated dimension and set "Suppress when value is Null"</P><P>If([<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">location group] &lt;&gt; '0',[<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">location group])</SPAN></SPAN></P></BODY></HTML> Tue, 11 Nov 2014 06:45:39 GMT https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806562#M284751 anbu1984 2014-11-11T06:45:39Z Re: suppress zero values in Group https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806563#M284752 <HTML><HEAD></HEAD><BODY><P>Hi Cheliyan,</P><P></P><P>thanks for ur quick response , i will try and let know.</P><P></P><P><BR /> </P></BODY></HTML> Tue, 11 Nov 2014 06:50:25 GMT https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806563#M284752 2014-11-11T06:50:25Z Re: suppress zero values in Group https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806564#M284753 <HTML><HEAD></HEAD><BODY><P>use calculated diemsion </P></BODY></HTML> Tue, 11 Nov 2014 07:01:32 GMT https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806564#M284753 sujeetsingh 2014-11-11T07:01:32Z Re: suppress zero values in Group https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806565#M284754 <HTML><HEAD></HEAD><BODY><P>Senthil,</P><P>Try this as calculated dimension:</P><P></P><P>=if (not isnull([<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">location group]</SPAN>),[<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">location group]</SPAN>)</P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Tue, 11 Nov 2014 07:04:27 GMT https://community.qlik.com/t5/QlikView/suppress-zero-values-in-Group/m-p/806565#M284754 amit_saini 2014-11-11T07:04:27Z