Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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