Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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
Highlighted
Partner
Partner

Re: How to Set Percentage in two expressions in chart

Hi,

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

Regards,

Gabriel

Highlighted
Not applicable

Re: How to Set Percentage in two expressions in chart

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

Thanks in advance

Ricardo