Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi Can you provide sample data/App so we could help? Thanks!
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.
Hi,
What is the problem you are facing while using the Partial Sum?
Regards,
Kaushik solanki