Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ederleelefon_gt
Partner - Contributor III

Qlikview Day to Day comparison

Hi All,

I just want to ask if you can share any ideas in doing a Qlikview Day to Day comparison, my requirement would be a continuous fetching of last year's day based on current year day. Any resources to read and apply would be gladly appreciated.

Please see image below as reference, my scenario would be from June 1, 2017 since it falls on Thursday. I would like to compare it with the first Thursday last year which happen to be June 2,2016 so on as the data progress my main aim is to have Day to Day comparison per year


Day to Day Data.PNG

2 Replies
sunny_talwar

I would suggest you to look into The As-Of Table

ederleelefon_gt
Partner - Contributor III
Author

I will look at this topic, thank you so much for your suggestion.