topic Point in Time Reporting in QlikView https://community.qlik.com/t5/QlikView/Point-in-Time-Reporting/m-p/1040327#M936075 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have been reading several discussion on this but unable to grasp the meaning of the formula used.</P><P></P><P>What i need is to create an automate dashboard that will update accordingly. Say today is Feb16. I would want the report to show the sales from Jan16 this year to Feb16 and compared with Same period last year. (Jan15 to Feb15)</P><P></P><P>I know i need to put some set time based modifier on this but not sure which best suit. either using addmonth function or dual function. What i know i need to use something like from and to as date today in the set modifier. </P><P></P><P>If anyone have any solution or links to this it will be greatly helps.</P></BODY></HTML> Tue, 16 Feb 2016 03:58:30 GMT Anonymous 2016-02-16T03:58:30Z Point in Time Reporting https://community.qlik.com/t5/QlikView/Point-in-Time-Reporting/m-p/1040327#M936075 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have been reading several discussion on this but unable to grasp the meaning of the formula used.</P><P></P><P>What i need is to create an automate dashboard that will update accordingly. Say today is Feb16. I would want the report to show the sales from Jan16 this year to Feb16 and compared with Same period last year. (Jan15 to Feb15)</P><P></P><P>I know i need to put some set time based modifier on this but not sure which best suit. either using addmonth function or dual function. What i know i need to use something like from and to as date today in the set modifier. </P><P></P><P>If anyone have any solution or links to this it will be greatly helps.</P></BODY></HTML> Tue, 16 Feb 2016 03:58:30 GMT https://community.qlik.com/t5/QlikView/Point-in-Time-Reporting/m-p/1040327#M936075 Anonymous 2016-02-16T03:58:30Z