topic Decimal dimension isn't collapsing in a chart object in QlikView https://community.qlik.com/t5/QlikView/Decimal-dimension-isn-t-collapsing-in-a-chart-object/m-p/483259#M180594 <HTML><HEAD></HEAD><BODY><P>My dimension is formed with</P><P></P><P>NUM(NGR,'###########,###.00') AS NGR_DEC2</P><P></P><P>My expression is</P><P></P><P>COUNT(PRIMARY_KEY)</P><P></P><P>The problem is that it's not collapsing NGR_DEC2 (group by).&nbsp; See screenshot.</P><P><IMG alt="2014-01-08 10_09_12-gmavmappdev08 - Remote Desktop.png" class="jive-image" src="/legacyfs/online/51237_2014-01-08 10_09_12-gmavmappdev08 - Remote Desktop.png" /></P></BODY></HTML> Wed, 08 Jan 2014 15:10:27 GMT 2014-01-08T15:10:27Z Decimal dimension isn't collapsing in a chart object https://community.qlik.com/t5/QlikView/Decimal-dimension-isn-t-collapsing-in-a-chart-object/m-p/483259#M180594 <HTML><HEAD></HEAD><BODY><P>My dimension is formed with</P><P></P><P>NUM(NGR,'###########,###.00') AS NGR_DEC2</P><P></P><P>My expression is</P><P></P><P>COUNT(PRIMARY_KEY)</P><P></P><P>The problem is that it's not collapsing NGR_DEC2 (group by).&nbsp; See screenshot.</P><P><IMG alt="2014-01-08 10_09_12-gmavmappdev08 - Remote Desktop.png" class="jive-image" src="/legacyfs/online/51237_2014-01-08 10_09_12-gmavmappdev08 - Remote Desktop.png" /></P></BODY></HTML> Wed, 08 Jan 2014 15:10:27 GMT https://community.qlik.com/t5/QlikView/Decimal-dimension-isn-t-collapsing-in-a-chart-object/m-p/483259#M180594 2014-01-08T15:10:27Z Re: Decimal dimension isn't collapsing in a chart object https://community.qlik.com/t5/QlikView/Decimal-dimension-isn-t-collapsing-in-a-chart-object/m-p/483260#M180595 <HTML><HEAD></HEAD><BODY><P>You probably want to use round() instead:</P><P>round(NGR, .01) AS NGR_DEC2</P></BODY></HTML> Wed, 08 Jan 2014 15:12:27 GMT https://community.qlik.com/t5/QlikView/Decimal-dimension-isn-t-collapsing-in-a-chart-object/m-p/483260#M180595 Nicole-Smith 2014-01-08T15:12:27Z