Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to increase accuracy in calculation

Hi

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.

PC

Tags (1)
7 Replies
varunjain
Contributor

Re: How to increase accuracy in calculation

TRY

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

varunjain
Contributor

Re: How to increase accuracy in calculation

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

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

Not applicable

Re: How to increase accuracy in calculation

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.

PC

amit_saini
Honored Contributor III

Re: How to increase accuracy in calculation

Baikand,

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

Thanks,

AS

amit_saini
Honored Contributor III

Re: How to increase accuracy in calculation

Also in expression side try something like below:

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

Thanks,

AS

varunjain
Contributor

Re: How to increase accuracy in calculation

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

MVP
MVP

Re: How to increase accuracy in calculation

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.

Community Browser