Week To date over the last few weeks

mid007 — Mon, 22 Jun 2020 15:41:21 GMT

Hi,

Goal

To have a week to date rolling view of my data. if the data in the current week is until Thursday. I want all the other data points in my bar chart to show Monday - Thursday so I can get a rolling week to date view history

(I have already set up my master calendar to take Monday as the first day of the week.)

Issue

I can't figure out how to limit previous weeks data to the same day in the week of the current week

I have attached an example of what I am trying to do along with my set analysis.

Thanks

Re: Week To date over the last few weeks

mid007 — Mon, 22 Jun 2020 15:43:18 GMT

Ignore the American data format in the attached excel. My dates are in DD/MM/YYYY format in Qlik and they work.

topic Week To date over the last few weeks in App Development

Week To date over the last few weeks

Re: Week To date over the last few weeks