Discussion Board for collaboration on QlikView Scripting.
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.
num(columnName,'###0.0000000000') this will show you calculation till 10 decimal points.
Try this in TEXT box... you ll get your result
I should have mentioned earlier that the calculation is in the reload and the '26' and '249' is a result of a APPLYMAP.
Better you check number tab of chart , you can set here the format as per your requirement.
Also in expression side try something like below:
You can use the mentioned parameter in the backend as well.
Try like this
num(Applymap('Table1', SomeValue))/num(Applymap('Table2', SomeValue2)) AS Newfield
Hope this helps you.