Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Same weekday last year

Hi,

I need to make a monthly chart (daily dimension) to compare sales the same day of this year against the sales of the same day of last year but, I need to compare monday with monday, tuesday with tuesday, and so on.

After a lot of try and error, I only can do this:

problem.PNG

How can I achive this comparation?

Thanks in advance.

Josep

5 Replies
vinafidalgo
Partner - Creator
Partner - Creator

Can you upload your QVW?

Clever_Anjos
Employee
Employee

Try to modify and use this approach: Relative Calendar Fields

hic is the guy

jonasheisterkam
Partner - Creator III
Partner - Creator III

Hi,

you can do it with a valueloop and add Day with the offset define by Weekday of Monthstart

Not applicable
Author

Maybe have a look at this also

http://community.qlik.com/docs/DOC-6593

should help in creating your required comparison flags

hope that helps

Joe

Not applicable
Author

Hi,

Thanks to all!

Finally i used a flag Week+weekday. It run ok for me.

Best Regards

Josep