Stacked bar Graph using proportion function

[#1]

Hello Team,

I have posted this 5 days back but no reply has come. Please help me out regarding this.

Scenario :

I have one complex problem where I need to show the Stacked bar chart in Qlikview using the Data in Excel.For  Reference I have provided both the stacked bar graphs and the excel data in the attached Excel file.

Please help me out regarding this as it is urgent.

Logic is explained in the excel itself.

Regards,

Hari

[SergeyMak]

Hi,

Try this expression for your chart.

=sum( Data)/sum( TOTAL <ProjYear> Data)