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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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