topic How to avoid 0.00 values in the table in QlikView https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215102#M68582 <HTML><HEAD></HEAD><BODY><P>HI, btechrames</P><P>&gt;you can go to the property menu&gt;presentation&gt;supress_zero values(mark).this will supress all zero values.</P></BODY></HTML> Thu, 23 Sep 2010 11:06:24 GMT Anonymous 2010-09-23T11:06:24Z How to avoid 0.00 values in the table https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215101#M68581 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>i am using pivot table to list the pdtname,currentmonthsale,previousmonthsale...</P><P>when i selected any one of the product in the table,the other unselected values of currentmonthsale,previousmonthsale...are became 0.00 ,So it disturbs the expression values calculation in the sheet and others,how to avoid this and i need the exact data to be displayed.</P><P>Pls,help me out....</P><P>Thanks in advance...</P></BODY></HTML> Thu, 23 Sep 2010 10:54:19 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215101#M68581 2010-09-23T10:54:19Z How to avoid 0.00 values in the table https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215102#M68582 <HTML><HEAD></HEAD><BODY><P>HI, btechrames</P><P>&gt;you can go to the property menu&gt;presentation&gt;supress_zero values(mark).this will supress all zero values.</P></BODY></HTML> Thu, 23 Sep 2010 11:06:24 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215102#M68582 Anonymous 2010-09-23T11:06:24Z How to avoid 0.00 values in the table https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215103#M68583 <HTML><HEAD></HEAD><BODY><P>That too was checked eventhough its coming ,i need that it wont affect other columns,,,,,,,,,</P></BODY></HTML> Thu, 23 Sep 2010 11:17:25 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215103#M68583 2010-09-23T11:17:25Z How to avoid 0.00 values in the table https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215104#M68584 <HTML><HEAD></HEAD><BODY><P> Can anyone respond to this question please?</P></BODY></HTML> Mon, 07 May 2012 13:27:38 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215104#M68584 Anonymous 2012-05-07T13:27:38Z How to avoid 0.00 values in the table https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215105#M68585 <HTML><HEAD></HEAD><BODY><P><BR />Hi, </P><P>in expression you convert the value like this&nbsp; and give supress_zero in presentation tab.<SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>num<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">OpexFY</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=Max(OpexFY))</EM></STRONG><EM style=": ; color: #808080; font-size: 8pt;"> </EM><SPAN style="color: #808080; font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">OrderedAmount</SPAN><SPAN style="font-size: 8pt;">),'#,##0') </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P></P><P><STRONG><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></STRONG></P><P></P><P></P><P></P></BODY></HTML> Tue, 29 May 2012 13:52:16 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-0-00-values-in-the-table/m-p/215105#M68585 Anonymous 2012-05-29T13:52:16Z