3 Replies Latest reply: Oct 20, 2011 5:55 AM by Kamal Naithani RSS

    round ?

    daniel_k Oct 19, 2011 10:06 AM

      Hello,

       

       

      i want to have a dynamic dimension

      that rounds an existing dimension at one position after the decimal point.

       

      Is the "QV round function" working similar to the "excel round function"?

       

       

      greetings

      daniel

      • 2528 Views
      • Tags:
        • round ?
          Stefan Wühl
          Stefan Wühl Oct 19, 2011 10:20 AM (in response to daniel_k)

          Well, both functions round so I guess they are similar...

           

          There are differences though, QV rounds takes a base as second parameter, so if you want to round to one decimal point, you need something like

           

          =round(Value, 0.1)

          where AFAIR Excel uses ROUND(CELL; 1)

           

          Does this answer your question?

          • round ?
            daniel_k Oct 19, 2011 10:23 AM (in response to daniel_k)

            thanks for your quick help

             

            you 're right excel is using the round function   Round (A1; 1)

             

            so long

            daniel

              • round ?
                Kamal Naithani
                Kamal Naithani Oct 20, 2011 5:55 AM (in response to daniel_k)

                HI Daniel ....in qlikview....for rounding we use the round()....go in the help tab..

                and there are other functions such as ceil and floor...which are used for get tghe value