Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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