Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

=round(sum(PARTS))

View solution in original post

5 Replies
swuehl
MVP
MVP

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

=round(sum(PARTS))

rajni_batra
Specialist
Specialist

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

Regards,

rajni

Not applicable
Author

Thanks a lot!

Not applicable
Author

Thanks a lot!

Not applicable
Author

Are you using  Round(Number,1)  ?