5 Replies Latest reply: Oct 24, 2013 6:53 AM by Mark Manders RSS

    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