Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

round ?

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

1 Solution

Accepted Solutions
MVP
MVP

round ?

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?

3 Replies
MVP
MVP

round ?

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?

Not applicable

round ?

thanks for your quick help

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

so long

daniel

kamalqlik
Valued Contributor

round ?

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