Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Problem with general Total in pivot table, and other

I have a pivot table (see in the picture), I have two problems:

1) I don't see the grand total at the bottom of the table, but only on the right divided by each year, and I don't even see the grand total on the right

2) I would need to do a set analysis for current month - 12 (month is the one marked in red) and not all months for selected years, but only for current year, current month - 12, my current expression is Sum(CONSUMI_SMC)

qlikmonthyear.jpg

3 Replies
danosoft
Specialist
Specialist
Author

Sorry but not solution for that in QlikView??

Langosh
Contributor
Contributor

I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.

PrepaidCardStatus

danosoft
Specialist
Specialist
Author

This is not the solution to my question.... but where i can see your webinar?

My questions are:

2) I would need to do a set analysis for current month - 12 (month is the one marked in red) and not all months for selected years, but only for current year, current month - 12, my current expression is Sum(CONSUMI_SMC)

and

1) I don't see the grand total at the bottom of the table, but only on the right divided by each year, and I don't even see the grand total on the right