Same weekday last year

[#1]

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:

How can I achive this comparation?

Thanks in advance.

Josep

[vinafidalgo]

Can you upload your QVW?

[Clever_Anjos]

Try to modify and use this approach: Relative Calendar Fields

hic is the guy

[jonasheisterkam]

Hi,

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

[#5]

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

[#6]

Hi,

Thanks to all!

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

Best Regards

Josep