
Creator III
2019-05-20
01:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rounding in Qlikview
HI,
i am writing some expression as per below
=num ( SUM ({<ScenarioLabel={'Actuals'},NumValue) /
SUM ({<ScenarioLabel={'Actuals'}>} DenValue), '0.#%')
its normal value is 78.26% which is good it is rounding to 78.3%
but same expression if value is 75.75% it is not rounding to 75.8 .. can some one help me here .
problem is after decimal if it is greater than 5 it is rounding if it is equal to 5 it is not rounding as per above example.
1,517 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
11 Replies


MVP
2019-06-11
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The rounding happens not on the right digits because it should round to the third digit and not the first, therefore change it to:
num(round(round(Expr1, 0.001) - round(Expr2, 0.001), 0.001), YourFormat)
- Marcus

Creator III
2019-06-11
06:17 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Marcus,
Excellent, it works 🙂 Thank You so Much .
267 Views

- « Previous Replies
-
- 1
- 2
- Next Replies »