topic Re: One decimal in QlikView

One decimal

danialier — Thu, 20 Mar 2014 17:26:44 GMT

Hello,

What else do I need to add to this formula so it only shows ONE decimal ?

=((num(sum({<Period={'Feb'},BA={'Net Revenues'}>}Amount)/1000))/
(num(sum({<Period={'Jan'},BA={'Net Revenues'}>}Amount)/1000))-1)*100

thks,dani

maxgro — Thu, 20 Mar 2014 17:30:24 GMT

=num(1/3, '#.##0,0')

EDIT: or go here (tablebox, chart) to choose format

Anonymous — Thu, 20 Mar 2014 17:31:34 GMT

just use the "round" funtion...for ex; round(3.88, 0, 1) = 3,9

its_anandrjs — Thu, 20 Mar 2014 17:31:58 GMT

Hi,

Try like this

=num( ((num(sum({<Period={'Feb'},BA={'Net Revenues'}>}Amount)/1000))/
(num(sum({<Period={'Jan'},BA={'Net Revenues'}>}Amount)/1000))-1)*100,'#,##0.0')

Hope this helps

Thanks & Regards

preminqlik — Thu, 20 Mar 2014 17:32:07 GMT

num(expression,'#.#')

or else go to number format tab and you can do over there

MK_QSL — Thu, 20 Mar 2014 17:32:12 GMT

NUM(yourexpression, '#,##0.0')

Thu, 20 Mar 2014 17:32:37 GMT

In addition:

Note that it is related to the setting of your decimal separator:

This is a setting that normally is set on the Main tab of your loadscript:

SET DecimalSep=',';

So when this value is a comma (like above) then this is correct

=num(1/3, '#.##0,0')

When it is a dot (like below)

SET DecimalSep='.';

=num(1/3, '#.##0.0')

is correct

its_anandrjs — Thu, 20 Mar 2014 17:42:25 GMT

Hi,

Check your decimal separator is and according to separator change comma or decimal in this script '#,##0.0'

=num( ((num(sum({<Period={'Feb'},BA={'Net Revenues'}>}Amount)/1000))/
(num(sum({<Period={'Jan'},BA={'Net Revenues'}>}Amount)/1000))-1)*100,'#,##0.0')

Otherwise change is Properties -> Number -> change fixed to upto 1 decimal place.

Hope this helps

Thanks & Regards