Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.