topic Setting decimal places on a dimension in QlikView

Setting decimal places on a dimension

hopkinsc — Wed, 16 Jun 2010 08:29:29 GMT

Hi, i need to set a value on a dimention to 2 decimal places. Its easy enough to do on an expression but i can't seem to set it on a dimension. Can anyone help please?>

Seiing decimal places on a dimension

Wed, 16 Jun 2010 08:36:40 GMT

Only way I can think of at the moment is to make it a calculated dimension, then use something like:

=Num(YourValueField,"#,##0.00")

Good luck,

Setting decimal places on a dimension

Wed, 16 Jun 2010 08:40:09 GMT

hi,

Add the dimension Age and then select the same and then press EDIT tab once in the tab write the expression

=num ( Age , '0.00')

This would solve your problem

Setting decimal places on a dimension

hopkinsc — Wed, 16 Jun 2010 08:58:10 GMT

Thanks very much, that worked. How would i get the £ symbol displayed also?

Setting decimal places on a dimension

Wed, 16 Jun 2010 09:07:58 GMT

Use this formula instead = money ( Age , '£#,#0.00')

Setting decimal places on a dimension

Wed, 16 Jun 2010 09:09:30 GMT

Simple, change the expression to Num( Age , '£0.00')

Setting decimal places on a dimension

hopkinsc — Wed, 16 Jun 2010 09:16:52 GMT

Excellent, thats worked great. thanks for your help everyone...

Re: Seiing decimal places on a dimension

TS60 — Wed, 06 Oct 2021 19:11:25 GMT

This solution does not work. I have two calculated dimensions which are formatted as dollars with two decimal places, and they display correctly. When I add those two dimensions to get a total (as a third dimension), it illogically displays a numeral with eleven decimal places and no dollar sign.