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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
jeanful
Partner - Contributor III
Partner - Contributor III

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 III
Partner - Contributor III
Author

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

View solution in original post

1 Reply
jeanful
Partner - Contributor III
Partner - Contributor III
Author

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