topic Re: question about round function in QlikView

question about round function

Mon, 19 May 2014 17:44:04 GMT

Hi ,

I am not able to understand the round function.

When I used round(78.32,1,1) it gave me 100

but when I used round(78.32,0.01) it gave me 78. Can anyone please explain this?

Re: question about round function

Mon, 19 May 2014 17:48:25 GMT

Here is an explanation of the function

How round function work in qlikview

Re: question about round function

Mon, 19 May 2014 18:07:08 GMT

Hi, I placed =round(78.32,1,1) into a text box and it displayed 78. I am unsure of what is wrong.

Re: question about round function

hic — Mon, 19 May 2014 18:44:52 GMT

You must be doing something else also, for example rounding in a second step on the Numbers tab. The Round() function does not work like you describe. See picture below

HIC

Re: question about round function

Mon, 19 May 2014 18:48:14 GMT

I am not sure but I guess since it's a percentage that's why I was getting the issue.

Re: question about round function

jaimeaguilar — Mon, 19 May 2014 19:31:55 GMT

Hi,

in the number tab use the option "Expression default" and then let the round function do the rest, so your number is expressed correctly,

regards

Re: question about round function

Tue, 20 May 2014 18:33:59 GMT

Thank you everyone. It worked