Solved: RangeSum not working for different days - Qlik Community

JD_2024 · ‎2024-02-08

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 · ‎2024-02-08

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?

View solution in original post

henrikalmen · ‎2024-02-08

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?

RangeSum not working for different days

General Question