topic Re: Sales Chart : Comparison Sales in QlikView https://community.qlik.com/t5/QlikView/Sales-Chart-Comparison-Sales/m-p/478345#M1136244 <HTML><HEAD></HEAD><BODY><P>Set up a master calendar with flags (search the forum) and then it's a piece of cake.</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar" style="font-style: inherit; font-family: inherit; color: #3778c7;">http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar</A></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields" style="font-style: inherit; font-family: inherit; color: #3778c7;">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields</A></P></BODY></HTML> Wed, 16 Oct 2013 13:20:58 GMT 2013-10-16T13:20:58Z Sales Chart : Comparison Sales https://community.qlik.com/t5/QlikView/Sales-Chart-Comparison-Sales/m-p/478343#M1136241 <HTML><HEAD></HEAD><BODY><P>I am New to qlikiview. Here is the business requirement:</P><P>- Chart to compare sales from the cureent date to the comparable date last year.</P><P>i.e compare 8/1/13 to 8/2/12, 8/2/13 to 8/3/12 etc...............</P><P></P><P>Sales Data is by date with the comparable date field in the table. The comparable date sales are in the table.</P><P></P><P>SalesDate</P><P>SalesDollars</P><P>SalesDateComp</P><P></P><P></P><P><BR /> </P></BODY></HTML> Wed, 16 Oct 2013 12:00:29 GMT https://community.qlik.com/t5/QlikView/Sales-Chart-Comparison-Sales/m-p/478343#M1136241 Anonymous 2013-10-16T12:00:29Z Re: Sales Chart : Comparison Sales https://community.qlik.com/t5/QlikView/Sales-Chart-Comparison-Sales/m-p/478344#M1136242 <HTML><HEAD></HEAD><BODY><P>Jeff</P><P></P><P>Sound like you wish to do what is often referred to as"Point in Time Reporting"</P><P></P><P>This blog post describes how to achieve this with QlikView.</P><P></P><P><A href="http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/" title="http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/">&nbsp;&nbsp;&nbsp;&nbsp; The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.</A></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Wed, 16 Oct 2013 12:34:31 GMT https://community.qlik.com/t5/QlikView/Sales-Chart-Comparison-Sales/m-p/478344#M1136242 Anonymous 2013-10-16T12:34:31Z Re: Sales Chart : Comparison Sales https://community.qlik.com/t5/QlikView/Sales-Chart-Comparison-Sales/m-p/478345#M1136244 <HTML><HEAD></HEAD><BODY><P>Set up a master calendar with flags (search the forum) and then it's a piece of cake.</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar" style="font-style: inherit; font-family: inherit; color: #3778c7;">http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar</A></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields" style="font-style: inherit; font-family: inherit; color: #3778c7;">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields</A></P></BODY></HTML> Wed, 16 Oct 2013 13:20:58 GMT https://community.qlik.com/t5/QlikView/Sales-Chart-Comparison-Sales/m-p/478345#M1136244 2013-10-16T13:20:58Z