topic Re: How to increase accuracy in calculation in QlikView

How to increase accuracy in calculation

Thu, 25 Sep 2014 06:45:21 GMT

How can I increase accuracy (Not just change the format using NUM())when calculating in reload?

For example, when I calculate 26/249, I want 0.1044176707.

If I use NUM() to increase the decimal points, it would just give me 0.10400000000

Thank you very much.

varunjain — Thu, 25 Sep 2014 06:50:45 GMT

TRY

num(columnName,'###0.0000000000') this will show you calculation till 10 decimal points.

varunjain — Thu, 25 Sep 2014 06:52:42 GMT

Try this in TEXT box... you ll get your result

=num(26/249,'###0.0000000000')

Thu, 25 Sep 2014 06:55:44 GMT

Hi Varun:

I should have mentioned earlier that the calculation is in the reload and the '26' and '249' is a result of a APPLYMAP.

Thank you.

amit_saini — Thu, 25 Sep 2014 06:55:45 GMT

Baikand,

Better you check number tab of chart , you can set here the format as per your requirement.

Thanks,

amit_saini — Thu, 25 Sep 2014 06:59:33 GMT

Also in expression side try something like below:

=Num(sum(ABC)/sum(XYZ),'####0.0000000000')

Thanks,

varunjain — Thu, 25 Sep 2014 07:00:11 GMT

You can use the mentioned parameter in the backend as well.

jagan — Thu, 25 Sep 2014 07:01:30 GMT

Hi,

Try like this

LOAD

num(Applymap('Table1', SomeValue))/num(Applymap('Table2', SomeValue2)) AS Newfield

FROM DataSource;

=num(26)/num(249)

Hope this helps you.

Regards,

jagan.