Discussion Board for collaboration related to QlikView App Development.
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?
Here is an explanation of the function
How round function work in qlikview
Hi, I placed =round(78.32,1,1) into a text box and it displayed 78. I am unsure of what is wrong.
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
I am not sure but I guess since it's a percentage that's why I was getting the issue.
in the number tab use the option "Expression default" and then let the round function do the rest, so your number is expressed correctly,
Thank you everyone. It worked