Sales Chart : Comparison Sales

[Anonymous]

I am New to qlikiview. Here is the business requirement:

- Chart to compare sales from the cureent date to the comparable date last year.

i.e compare 8/1/13 to 8/2/12, 8/2/13 to 8/3/12 etc...............

Sales Data is by date with the comparable date field in the table. The comparable date sales are in the table.

SalesDate

SalesDollars

SalesDateComp

[Anonymous]

Jeff

Sound like you wish to do what is often referred to as"Point in Time Reporting"

This blog post describes how to achieve this with QlikView.

     The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.

Best Regards,     Bill

[#3]

Set up a master calendar with flags (search the forum) and then it's a piece of cake.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields