topic Re: Show Calculated Total on Extreme right side of Pivot Table in QlikView

Show Calculated Total on Extreme right side of Pivot Table

sujit_nath — Sat, 16 Nov 2024 01:37:27 GMT

I have a data in Qlikview pivot table as shown -

I have created a the dimension forecast as an inline table with the values Plan, Actual, Deviation and Level. There are months which do not have any Plan data, so I'm not showing them and the deviation is hidden as well in that case.
The expression I'm using is simply sum(Expense)

Now I want to show the data highlighted in Green. I am unable to achieve this through the show partial sum feature of Qlikview on presentation Tab.
I need some other way to get this value.
Could someone help me get a solution to this, as this data would show the Total for the department throughout the year. (In this screenshot, I've shown only three months, but the actual data would contain all the months and quarters)

Re: Show Calculated Total on Extreme right side of Pivot Table

alex00321 — Mon, 30 Dec 2019 06:22:12 GMT

Hi Can you provide sample data/App so we could help? Thanks!

Re: Show Calculated Total on Extreme right side of Pivot Table

sujit_nath — Mon, 30 Dec 2019 09:12:10 GMT

So Sorry Alex, I'm restricted to share app and data due to Enterprise restrictions 😞 I'm trying to bear around the bush on this.

Re: Show Calculated Total on Extreme right side of Pivot Table

kaushiknsolanki — Mon, 30 Dec 2019 09:40:34 GMT

Hi,

What is the problem you are facing while using the Partial Sum?

Regards,

Kaushik solanki