Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you upload your QVW?
Try to modify and use this approach: Relative Calendar Fields
hic is the guy
Hi,
you can do it with a valueloop and add Day with the offset define by Weekday of Monthstart
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
Hi,
Thanks to all!
Finally i used a flag Week+weekday. It run ok for me.
Best Regards
Josep