topic Re: Expression not rounding off correctly in QlikView

Expression not rounding off correctly

fashid — Thu, 28 Jan 2016 13:10:23 GMT

Hi,

Hi Experts,

I have an expression named MTD score which is not rounding off correctly

It should round off to 17 but for some other reason it does not work.

I am attaching the sample qvw.

Also this error was captured on 25th Jan 2016 , so maybe if you want to open the qvw and replicate the issue you might have to change the clock on your system .

Regards,

Nadeem

Re: Expression not rounding off correctly

Anonymous — Thu, 28 Jan 2016 13:12:35 GMT

Have a read of this Blog Post by Henric :

Rounding Errors

Re: Expression not rounding off correctly

sunny_talwar — Thu, 28 Jan 2016 13:19:47 GMT

The issue here is that the Column(3)'s output seems like its 92, but its actually 91.6666666 which leads to an MTD Score of 16.50. 16.50 is getting rounded to 16, instead of 17.

Re: Expression not rounding off correctly

Thu, 28 Jan 2016 13:24:07 GMT

Firstly your MTD expression returning 85 not 92 so you are getting 15. Don't use ROund functions in your expressions.

Directly user the Number format on the Number tab.

Re: Expression not rounding off correctly

sunny_talwar — Thu, 28 Jan 2016 13:25:34 GMT

I think that is because he is using Today() function and the issue was found on Jan 25th (3 days ago). I have attached the app with Today()-3. You can check it out there.

Re: Expression not rounding off correctly

fashid — Thu, 28 Jan 2016 13:35:09 GMT

hi Sunny ,

Now what should i do if i want the MTD score to be calculated on the rounded off MTD percentage column .

Regards,

Nadeem

Re: Expression not rounding off correctly

sunny_talwar — Thu, 28 Jan 2016 13:37:53 GMT

Try this:

=if((((18/100)*Column(3))*100)>18,18,Round((((18/100)*Round(Column(3), 0.01))*100)))

Re: Expression not rounding off correctly

HirisH_V7 — Thu, 28 Jan 2016 14:18:48 GMT

Hi,

In your MTD Score Expression,

=if((((18/100)*Column(3))*100)>18,18,(((18/100)*Column(3))*100))

now for that particular loaded field is , 15.23

Hope this Helps,

PFA,

Hirish

Re: Expression not rounding off correctly

fashid — Thu, 28 Jan 2016 17:32:16 GMT

Thanks a lot sunny,

But i plan to keep the expressions same as i have many of them and i suspect that it may cause further issues .

My question remains so as to why does qlikview not round off 16.50 to 17 .

When i use a text object and enclose 16.50 in the round function it gives me 17 but fails to do this in my chart.

Regards,

Nadeem

Re: Expression not rounding off correctly

sunny_talwar — Thu, 28 Jan 2016 17:35:08 GMT

Have you looked at the link shared by Bill above? If you have not, look again -> Rounding Errors

Re: Expression not rounding off correctly

fashid — Thu, 28 Jan 2016 17:40:36 GMT

Sorry I did not look into it My Bad

Thanks got it

Re: Expression not rounding off correctly

sunny_talwar — Thu, 28 Jan 2016 17:41:46 GMT

No problem. We are glad we were able to help

Re: Expression not rounding off correctly

fashid — Thu, 28 Jan 2016 17:42:55 GMT

Thanks as always you guys RoCK !!!!

Re: Expression not rounding off correctly

Anonymous — Thu, 28 Jan 2016 17:47:16 GMT

..... 'n Roll