Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
Partner

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
Partner

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