topic Re: Showing expression as dimension in pivot table in QlikView

Showing expression as dimension in pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have to create a report which contain strategic code,KPI as dimension.And my expressions are actual,previous year, and annual budget plan .

My problem is that I dont have strategic code and KPI fields in my source table.

Kindly find the below screen shot for your understanding

Re: Showing expression as dimension in pivot table

sunny_talwar — Mon, 11 Apr 2016 10:11:32 GMT

Is that information, I mean strategic code and KPI field coming in from other source? or are they static and can be created in the script using Inline table?

Would you be able to share some raw data of what you have and what is your intended solution?

Re: Showing expression as dimension in pivot table

Tue, 12 Apr 2016 06:31:23 GMT

Hi Sunny,

Thanks for your reply,yes strategic code and KPI are static,the screen shot which I posted is not my source file .

the source file is different.Turnover,gross margin etc need to be calculated from that source file .

kindly let me know any more information you want from my side

Re: Showing expression as dimension in pivot table

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:08:12 GMT

Post a small qlikview document that demonstrates the problem and an excel file with source data and your calculations.