topic Negative zero display in QlikView https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358663#M577966 <HTML><HEAD></HEAD><BODY><P> I think I figured it out now. I used the number format and used precision 2 and the pattern as ##%. Although the preview shows as 3.6e+006%, but my chart looks ok as it is not displaying that way.Thanks again for the quick response</P></BODY></HTML> Mon, 19 Mar 2012 17:09:12 GMT 2012-03-19T17:09:12Z Negative zero display https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358658#M577961 <HTML><HEAD></HEAD><BODY><P> I am getting a negative sign displayed in front of zeros e.g (-0). How do I remove the negative sign, any idea why it is showing this behavior?. See attached. </P></BODY></HTML> Mon, 19 Mar 2012 16:25:01 GMT https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358658#M577961 2012-03-19T16:25:01Z Negative zero display https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358659#M577962 <HTML><HEAD></HEAD><BODY><P>Could it be in the negative by decimal?</P></BODY></HTML> Mon, 19 Mar 2012 16:26:59 GMT https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358659#M577962 2012-03-19T16:26:59Z Negative zero display https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358660#M577963 <HTML><HEAD></HEAD><BODY><P> Explain please</P></BODY></HTML> Mon, 19 Mar 2012 16:50:47 GMT https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358660#M577963 2012-03-19T16:50:47Z Negative zero display https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358661#M577964 <HTML><HEAD></HEAD><BODY><P>To verify my theory, I'd first go into my numbering layout for this column and change it to show decimal point. </P><P></P><P>The true value could be -0.01%, making it in the negative although you're only showing the whole number.</P><P></P><P>I could be wrong but you said any idea why it is showing this behavior, might be worth checking.</P></BODY></HTML> Mon, 19 Mar 2012 16:53:49 GMT https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358661#M577964 2012-03-19T16:53:49Z Negative zero display https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358662#M577965 <HTML><HEAD></HEAD><BODY><P> You are right, I have it in the number tab as fixed, format pattern : <SPAN style="font-size: 8pt;"></SPAN></P><P><STRONG>#,##0% . if I change it to number and pattern as</STRONG></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>####,###% </P>then it shows -0.138036. I really don't want to show that length<P></P><P></P><P></P></BODY></HTML> Mon, 19 Mar 2012 17:04:04 GMT https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358662#M577965 2012-03-19T17:04:04Z Negative zero display https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358663#M577966 <HTML><HEAD></HEAD><BODY><P> I think I figured it out now. I used the number format and used precision 2 and the pattern as ##%. Although the preview shows as 3.6e+006%, but my chart looks ok as it is not displaying that way.Thanks again for the quick response</P></BODY></HTML> Mon, 19 Mar 2012 17:09:12 GMT https://community.qlik.com/t5/QlikView/Negative-zero-display/m-p/358663#M577966 2012-03-19T17:09:12Z