Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
kodekrackerz
Contributor
Contributor

Display day stats (sum) from last 8 weeks on selected date

Let us take and example:-

1. If you are selecting 16/08/2022 as Date, it is Tuesday so I want to display Tuesday data (sum value) for past 8 weeks like 16/08, 09/08, 02/08, 26/07, 19/07, 12/07, 05/07, 28/06

2. If you select 11/08/2022 which was Thursday, so it should display  11/08, 04/08,  28/07, 21/07, 14/07, 07/07, 30/06, 23/07

1 Reply
marcus_sommer

You may use something like:

sum({< Date = {">=$(max(Date)-56)<=$(max(Date))"}, WeekDay = {"$(=max(WeekDay)"}>} Value)

- Marcus