
Re: Improving the accuracy of calculations
Tresesco B Aug 21, 2014 5:21 AM (in response to Georgia Psyllidou)Not sure if I understood right. Have you checked the number tab (of a chart)? You can set precision for metrics there.

Re: Improving the accuracy of calculations
Georgia Psyllidou Aug 21, 2014 5:29 AM (in response to Tresesco B)Hi and many thanks for your reply 
indeed I have checked that and all it does is increasing the number of decimals ie
if initial number is 15,34% (x2) this can get me to 15,33456...%
However I want my calculation to return something like 15,42% (x1 calculated offline with A,B, C also in Qlik, so same basis) which cannot be fixed with that.
thx
G


Re: Improving the accuracy of calculations
shariq ahmed Aug 21, 2014 5:23 AM (in response to Georgia Psyllidou)hi, Georgia
If your are using this calculation in graph or table go properties then number tab
select your expression and set your precision and decimal accuracy....
Regards
Fahad

Re: Improving the accuracy of calculations
Georgia Psyllidou Aug 21, 2014 5:30 AM (in response to shariq ahmed)Hi Fahad and many thanks for your reply / same as above...
indeed I have checked that and all it does is increasing the number of decimals ie
if initial number is 15,34% (x2) this can get me to 15,33456...%
However I want my calculation to return something like 15,42% (x1 calculated offline with A,B, C also in Qlik, so same basis) which cannot be fixed with that.
thx
G

Re: Improving the accuracy of calculations
shariq ahmed Aug 21, 2014 5:36 AM (in response to Georgia Psyllidou)Dear G
can you give me the value of
a,b,c for your expression (AB)/C.
Regards
FAHAD

Re: Improving the accuracy of calculations
shariq ahmed Aug 21, 2014 6:04 AM (in response to shariq ahmed)May be you need to use round function in your expression....
if i assume your value
=round(15.33456,0.2)
=15.4%

Re: Improving the accuracy of calculations
Georgia Psyllidou Aug 21, 2014 6:14 AM (in response to shariq ahmed)Hi Fahad,
I reproduced this in a straight table and discovered that there was an error in my A,B calcs inside the metric.
(not very suprising I suppose) which cause the discrepancy and not the accuracy of qlik.
I generally prefer laying calculations in detail in pivots rather than referencing other expressions, at the cost of human errors inserted.
thanks for the attention
G


