topic Re: Make negative zero as positive zero in pivot table in QlikView https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013178#M930355 <HTML><HEAD></HEAD><BODY><P>May be something like this:</P><P></P><P><STRONG>fabs(YourExpression4Difference)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>If(</STRONG><STRONG style="font-size: 13.3333px;">YourExpression4Difference &gt;= -1 and <STRONG style="font-size: 13.3333px;">YourExpression4Difference &lt;= 0, 0, <STRONG style="font-size: 13.3333px;">YourExpression4Difference)</STRONG></STRONG></STRONG></P></BODY></HTML> Thu, 17 Mar 2016 09:36:22 GMT sunny_talwar 2016-03-17T09:36:22Z Make negative zero as positive zero in pivot table https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013177#M930354 <HTML><HEAD></HEAD><BODY><P>Greetings</P><P></P><P>Can someone help me to convert the negative zero value as positive in pivot table. I would like to highlight the cell value which is less than 0.</P><P></P><P>Please assist.</P><P>Thanks</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118371_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013177#M930354 2020-11-25T16:16:04Z Re: Make negative zero as positive zero in pivot table https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013178#M930355 <HTML><HEAD></HEAD><BODY><P>May be something like this:</P><P></P><P><STRONG>fabs(YourExpression4Difference)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>If(</STRONG><STRONG style="font-size: 13.3333px;">YourExpression4Difference &gt;= -1 and <STRONG style="font-size: 13.3333px;">YourExpression4Difference &lt;= 0, 0, <STRONG style="font-size: 13.3333px;">YourExpression4Difference)</STRONG></STRONG></STRONG></P></BODY></HTML> Thu, 17 Mar 2016 09:36:22 GMT https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013178#M930355 sunny_talwar 2016-03-17T09:36:22Z Re: Make negative zero as positive zero in pivot table https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013179#M930356 <HTML><HEAD></HEAD><BODY><P>You need to use rounding-functions like round(YourExpressionForColumn1) - round(YourExpressionForColumn2), see also: <A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 17 Mar 2016 09:36:44 GMT https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013179#M930356 marcus_sommer 2016-03-17T09:36:44Z Re: Make negative zero as positive zero in pivot table https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013180#M930357 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=</SPAN><EM style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">dual(fabs(sum(urexp))</EM></P><P><EM style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">or chk below</EM></P><P><EM style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/message/912431">Re: Negative values in chart</A></EM></P></BODY></HTML> Thu, 17 Mar 2016 09:39:51 GMT https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013180#M930357 Chanty4u 2016-03-17T09:39:51Z Re: Make negative zero as positive zero in pivot table https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013181#M930358 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!!</P><P></P><P>It did work.</P></BODY></HTML> Thu, 17 Mar 2016 09:41:54 GMT https://community.qlik.com/t5/QlikView/Make-negative-zero-as-positive-zero-in-pivot-table/m-p/1013181#M930358 2016-03-17T09:41:54Z