topic Re: Negative Zero in QlikView https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559791#M208937 <HTML><HEAD></HEAD><BODY><P>Yes, specify a format pattern that includes a format to display negative numbers without the - sign. For example #.0;#.0</P></BODY></HTML> Mon, 05 Aug 2013 15:33:01 GMT Gysbert_Wassenaar 2013-08-05T15:33:01Z Negative Zero https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559790#M208936 <HTML><HEAD></HEAD><BODY><P>In a staright chart, the expression default is:</P><P></P><P>-0.0004699869</P><P></P><P>I selected, Fixed To 1 Decimal and Show in Percent (%) under Number tab</P><P></P><P>and it becomes:</P><P></P><P>-0.0%</P><P></P><P>Is it possible that after this number formatting, if the result is 0, it shows up as:</P><P></P><P>0% in chart ?</P></BODY></HTML> Mon, 05 Aug 2013 15:29:25 GMT https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559790#M208936 Anonymous 2013-08-05T15:29:25Z Re: Negative Zero https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559791#M208937 <HTML><HEAD></HEAD><BODY><P>Yes, specify a format pattern that includes a format to display negative numbers without the - sign. For example #.0;#.0</P></BODY></HTML> Mon, 05 Aug 2013 15:33:01 GMT https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559791#M208937 Gysbert_Wassenaar 2013-08-05T15:33:01Z Re: Negative Zero https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559792#M208938 <HTML><HEAD></HEAD><BODY><P>Use Floor(Fabs(expression))</P></BODY></HTML> Mon, 05 Aug 2013 15:33:49 GMT https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559792#M208938 nagaiank 2013-08-05T15:33:49Z Re: Negative Zero https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559793#M208939 <HTML><HEAD></HEAD><BODY><P>You probably want to show larger negative numbers still with a minus sign and with 1 decimal.</P><P></P><P>You can specify the format in your expression, leaving the numbers tab option on expression default, something like</P><P></P><P>=if(fabs(VALUE)&lt;5E2, num(0 ,'0%'), num(VALUE ,'0,0%') )</P></BODY></HTML> Mon, 05 Aug 2013 15:37:01 GMT https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559793#M208939 swuehl 2013-08-05T15:37:01Z Re: Negative Zero https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559794#M208940 <HTML><HEAD></HEAD><BODY><P>Thank you all for your reponses.</P></BODY></HTML> Mon, 05 Aug 2013 18:39:36 GMT https://community.qlik.com/t5/QlikView/Negative-Zero/m-p/559794#M208940 Anonymous 2013-08-05T18:39:36Z