topic Re: Inconsistent Rounding results in qlikview in QlikView

Inconsistent Rounding results in qlikview

Tue, 26 Sep 2017 11:03:36 GMT

The below script is returning different rounding results. However I am expecting the result to be 0.7767 in place of IncorrectRoundResult column. How can this be fixed without using CEIL?

RoundData:

LOAD

round(Num1/Num2,0.0001) as IncorrectRoundResult,

Num1/Num2 as NoRoundResult,

round(0.77665,0.0001) as CorrectRoundResult;

LOAD* INLINE

[

Num1, Num2

978579,1260000

]

;

Re: Inconsistent Rounding results in qlikview

sunny_talwar — Tue, 26 Sep 2017 11:09:56 GMT

Look at this thread

Rounding Errors

Re: Inconsistent Rounding results in qlikview

Anil_Babu_Samineni — Tue, 26 Sep 2017 11:10:09 GMT

This should return =Round(978579/1260000,0.0001)

Re: Inconsistent Rounding results in qlikview

PrashantSangle — Tue, 26 Sep 2017 11:17:16 GMT

Use ceil instead of round

Regards

Re: Inconsistent Rounding results in qlikview

Tue, 26 Sep 2017 11:18:04 GMT

I need to use the column names but not the actual values. When the actual values are used, it provides correct intended result

Re: Inconsistent Rounding results in qlikview

Tue, 26 Sep 2017 11:21:48 GMT

Ceil has issues like it would return 0.7666 for ceil(0.76653,0.0001)

Re: Inconsistent Rounding results in qlikview

Anil_Babu_Samineni — Tue, 26 Sep 2017 11:22:27 GMT

Sunny already provide nice article. You can look diff of Floor and Ceil..

Re: Inconsistent Rounding results in qlikview

Anil_Babu_Samineni — Tue, 26 Sep 2017 11:24:08 GMT

From Sunny provided link, i used ceil to get into work

Re: Inconsistent Rounding results in qlikview

marcus_malinow — Tue, 26 Sep 2017 12:06:52 GMT

How about this?

A bit kludgy, but it works.

round(round(Num1/Num2, 0.00001),0.0001) as CorrectRoundResult,

Re: Inconsistent Rounding results in qlikview

Tue, 26 Sep 2017 14:02:44 GMT

Thank you Marcus. It worked.