Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to add rounding to your expression, not using a number formatting rounding:
=round(sum(PARTS))
Try to add rounding to your expression, not using a number formatting rounding:
=round(sum(PARTS))
in expression use round() function
round("Your expression")
Regards,
rajni
Thanks a lot!
Thanks a lot!
Are you using Round(Number,1) ?