Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

2 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

First thing to mind is create same expression again and format it to show % then hide the chart.

Regards,

Gabriel

Not applicable
Author

I have two expressions, one for year 2011 and other for year 2011R. Could you please detail de steps ?

Thanks in advance

Ricardo