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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Pivot table: make Sum current month - 12

I have a pivot table (image), as dimensions I have YEAR, MONTH, company name, pdr. As an Expression I have Sum (CONSUMO_SMC)
I would need by selecting the years 2021 and 2020 that this table would show me the Sum (CONSUMO_SMC) from the current month to the current month -12 is it possible?

1Qlik.jpg

.. and i add: I would also like to have in the last column, after the Grand total, the total number of MONTHS that have a value> 0

0 Replies