29 Replies Latest reply: Aug 17, 2015 5:47 AM by Yakub Ali RSS

    Round off value incorrect

      Hi QlikView users,

       

      I would  like to seek help, I am having a problem on the rounding of of the values, I have a value of 1.5 which is derived from 1500000 divided by 1000 to get value in million then when on chart. I used the number format fixed to and integer the value shows the value of 1. I also then tried this solution, Round(Sum(Fieldname) *10/10,0.1) it got the correct answer, but it affected the other values.

       

      Please help on how to round off correctly to integer.

       

      Thanks in advance

       

      Royce