2 Replies Latest reply: Mar 13, 2013 11:53 AM by Ricardo Gonçalves RSS

    How to Set Percentage in two expressions in chart

      Hello,

       

      i'm a newbie in qlikview and have a basic problem.  I need to create a bar chart where the value in the data points of the expressions must have the following appearance , Total Value / Percentage :

       

      percentage_graph.png

       

      The Percentage is calculated by dividing the Total Value with Total Value of Categ 1 in the corresponding year.

       

      How can i acomplish this in qlikview?

       

      PS: I attached a xls file with data and chart for clarification.

       

      Thanks in advance.