topic round ? in QlikView

round ?

Wed, 19 Oct 2011 14:06:39 GMT

Hello,

i want to have a dynamic dimension

that rounds an existing dimension at one position after the decimal point.

Is the "QV round function" working similar to the "excel round function"?

greetings

daniel

swuehl — Wed, 19 Oct 2011 14:20:49 GMT

Well, both functions round so I guess they are similar...

There are differences though, QV rounds takes a base as second parameter, so if you want to round to one decimal point, you need something like

=round(Value, 0.1)

where AFAIR Excel uses ROUND(CELL; 1)

Does this answer your question?

Wed, 19 Oct 2011 14:23:28 GMT

thanks for your quick help

you 're right excel is using the round function Round (A1; 1)

so long

daniel

kamalqlik — Thu, 20 Oct 2011 09:55:10 GMT

HI Daniel ....in qlikview....for rounding we use the round()....go in the help tab..

and there are other functions such as ceil and floor...which are used for get tghe value