2 Replies Latest reply: Dec 17, 2010 9:43 AM by rgebhart RSS

    Value A in % of Value B

      Dear all,

      I am a new QlikView user and came now to a point where I need your help. I have a very easy revenue data model consisting of a view dimensions only. I use a straight table where I display revenue for Scenarion Actual and Scenarion AOP in 2 rows. I want to add a funcition preffered in a 3rd row which is telling me the % of actual compared to plan. Here is how my table looks like.

      Scenario EUR
      Actual 90
      AOP 100

      The 3rd (new row) should now display 90%. Alternatively - if it is easier - I can also use a 3rd column...

      Can somebody help me?

      Many thanks in advance

      Rainer