Calculate Aggregate Functions in Pivot Tables

[waqasshah]

Dear All,

I am facing difficulty in creating pivot chart in qlikview. To manage calculations and dimension is a big  issue.

I have attached the excel sheet. It has sample data in first sheet  and the next sheet has targeted dashboard. Can some one please help ?

Many Thanks

Kind Regards

Waqas Shah

[andrey_krylov]

Maybe somehow  like this

[waqasshah]

Dear Andrey,

Thanks for your try but I would like to hide the column when there is no data or zero values. Like in your QVW file last column "2016/2017 change from previous year %" has zero value. I want this column to be hidden.

Can you hide it ?

Kind Regards

Waqas Shah

[thannila]

Hi,

     I have attached the Application based on your requirement.Please check it.

[andrey_krylov]

I'm not sure, but maybe this

[waqasshah]

Sorry I have qlikview only not Qlik sense... can you please semd me qvw file?