Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Rounding problems in Qlikview

Hi,

I have an expression which sums up parts, it could be for e.g. 0,4 parts or 0,6 parts. Does anyone know if it's possible to arrange in Qlikview that the parts are automatically rounded so that 0,4 parts = 0 and 0,6 parts = 1. In Qlikview now it is already rounded but when I export to excel the decimals shows.

Thanks!

Sofie

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Rounding problems in Qlikview

Try to add rounding to your expression, not using a number formatting rounding:

=round(sum(PARTS))

5 Replies
MVP
MVP

Re: Rounding problems in Qlikview

Try to add rounding to your expression, not using a number formatting rounding:

=round(sum(PARTS))

rajni_batra
Valued Contributor

Re: Rounding problems in Qlikview

in expression use round() function
round("Your expression")

Regards,

rajni

Not applicable

Re: Rounding problems in Qlikview

Thanks a lot!

Not applicable

Re: Rounding problems in Qlikview

Thanks a lot!

Not applicable

Re: Rounding problems in Qlikview

Are you using  Round(Number,1)  ?


Community Browser