Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display the total sum for each product based on Year Quarter

I have three variables - Products, Price and YearQuarter. I need to display the total sum for each product based on Year Quarter. I am trying to find a way to aggregate the sum of each year and display the totals. As of now, I see the total amount for all.

Product2016-Q12016-Q22016-Q32016-Q42016 Total2017-Q12017-Q22017-Q32017-Q42017 Total
X
Y
Z
1 Solution

Accepted Solutions
pablolabbe
Luminary Alumni
Luminary Alumni

Add the Year dimension to your pivot table to set the Total by Year.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

View solution in original post

2 Replies
pablolabbe
Luminary Alumni
Luminary Alumni

Add the Year dimension to your pivot table to set the Total by Year.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

Anonymous
Not applicable
Author

Thank you