Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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