Filtering a table with accumulation modifier by dates

[richardcinca]

 Hi all,

In a table with a column with daily dates (mm/dd/yyyy), a column with a measure sum(amount) and a column with an accumulation modifier steps:30,  is there any way to filter the table by date  (ex. */15/2021) to get the  accumulation values for all 15th of months of 2021 ? When using the table filter, the values will be recalculated using the filtered table resulting wrong accumulation values.

Thank you!

[Davis69]

---

@richardcinca wrote: WestPenn Power

 Hi all,

In a table with a column with daily dates (mm/dd/yyyy), a column with a measure sum(amount) and a column with an accumulation modifier steps:30,  is there any way to filter the table by date  (ex. */15/2021) to get the  accumulation values for all 15th of months of 2021 ? When using the table filter, the values will be recalculated using the filtered table resulting wrong accumulation values.

Thank you!

---

What this member wants to do is to show only the Cumulative Total for a specific time period without affecting any of the original results?

[richardcinca]

Yes, when the user is filtering by the date such as :

 It needs to return the original values for these dates calculated in the table,  further to be able to plot them to  a bar chart presenting the 30Day Cumulative Total for the 15th of each month.

Thank you

[vinieme12]

In your calendar just create a Day field

,Day(Date) as CalendarDay

Then in set analysis just do below to sum only 15th for all months in the selected/max year

sum( {<Year={"=Max(Year)"} , CalendarDay={'15'}>}  SomeMeasure )

learn about accumulative sums here

https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums