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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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