RangeSum not working for different days

[JD_2024]

Hello All,

I would like to request your support with the following Pivot Table.

I'm trying to get the accumulated value by type with a rangesum(). However, Qlik is not proving any information when the day is changing. 

Do you have a solution for this? The idea is to sum the amount even if we have different days.

Thank you

[henrikalmen · Accepted solution]

There is no data for Archived, Closed and Total for the date 08-02-24. If you expect values in the cells you marked with yellow, you need to check your data model so that there actullay are values for the combination of these types and the given date. If there is, something may be wrong with how you defined the pivot table. What did you expect to see where you marked the cells yellow?