topic Re: How to fix to one decimal in QlikView

How to fix to one decimal

danialier — Fri, 21 Feb 2014 15:39:24 GMT

Hello,

I have the following formula which gives me the result but with a bunch of decimals. How can I fix this to just showing one decimal ?

= sum({<[Product Line]={'Hardware'}>}Units)/sum({<[Product Line]={'Supplies'}>}Units)

thanks,dani

Nicole-Smith — Fri, 21 Feb 2014 15:40:37 GMT

num(sum({<[Product Line]={'Hardware'}>}Units)/sum({<[Product Line]={'Supplies'}>}Units),'#,##0.0')

Fri, 21 Feb 2014 15:42:38 GMT

Hi,

fromat it with num():

num(sum({<[Product Line]={'Hardware'}>}Units)/sum({<[Product Line]={'Supplies'}>}Units) , '#.##0,0')

MK_QSL — Fri, 21 Feb 2014 15:43:23 GMT

NUM(YourExpression, '#,##0.0')

Fri, 21 Feb 2014 15:43:25 GMT

Hi Nicole,

fast as lightning ;-))

Regards

Roland

Fri, 21 Feb 2014 15:44:41 GMT

Try this

under Number in the format pattern type #,##0.0

danialier — Fri, 21 Feb 2014 15:47:41 GMT

excellent ! thanks