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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jeanful
Partner - Contributor II
Partner - Contributor II

Subtotal of nested loop over levels does not match

Hello, I built a pixel perfect template in QS Cloud. I have the following configuration:

- Created a level called "Table Export"

- Created the "DetailReport1" section: here I configured the data member as "Table Export" level

- Under the "DetailReport1" I have a group header section, a detail section, a group footer section

- In header I put some titles, the month (the need is iterating over the month, i.e. one month -> one page) and a subtotal of the month. To do so, I configured Group Union: with first detail; Group By: Month

- In detail I put the labels coming from the level, so I built a table with all the rows of the level

- In footer I put the subtotal. I configured Group Union: with first detail, No Group By option here.

 

While the month in header is correct, the subtotals (both in header and in footer) are wrong. They show the total amount of all the months, instead of the one of the month of the page.

Thank you for supporting!

Labels (1)
1 Solution

Accepted Solutions
jeanful
Partner - Contributor II
Partner - Contributor II
Author

Just found the function SumSum! That's what I needed 

View solution in original post

1 Reply
jeanful
Partner - Contributor II
Partner - Contributor II
Author

Just found the function SumSum! That's what I needed