Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
mid007
Contributor
Contributor

Week To date over the last few weeks

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

 

Labels (1)
1 Reply
mid007
Contributor
Contributor
Author

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