Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ignore the American data format in the attached excel. My dates are in DD/MM/YYYY format in Qlik and they work.