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"?
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
where AFAIR Excel uses ROUND(CELL; 1)
Does this answer your question?
thanks for your quick help
you 're right excel is using the round function Round (A1; 1)
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
Retrieving data ...