topic Re: Same weekday last year in QlikView

Same weekday last year

Fri, 16 Jan 2015 15:57:49 GMT

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

Re: Same weekday last year

vinafidalgo — Fri, 16 Jan 2015 16:21:21 GMT

Can you upload your QVW?

Re: Same weekday last year

Clever_Anjos — Fri, 16 Jan 2015 16:23:30 GMT

Try to modify and use this approach: Relative Calendar Fields

hic is the guy

Re: Same weekday last year

jonasheisterkam — Fri, 16 Jan 2015 17:12:40 GMT

Hi,

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

Re: Same weekday last year

Fri, 16 Jan 2015 17:19:06 GMT

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

Re: Same weekday last year

Mon, 19 Jan 2015 20:38:28 GMT

Hi,

Thanks to all!

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

Best Regards

Josep