topic Date Comparison Analysis in QlikView https://community.qlik.com/t5/QlikView/Date-Comparison-Analysis/m-p/847118#M1017825 <HTML><HEAD></HEAD><BODY><P>Given the following Table, I need to compare the Quantity a Month, Quarter Half-Year and Year Ago plus the difference agaisnt YTD (same period of last calendar Year):</P><P></P><P>LOAD * INLINE</P><P>[Date, Product, Qty </P><P>08/01/2015, Shoes,&nbsp; 7</P><P>01/12/2014, Shoes, 10</P><P>01/12/2014, Shoes, 46</P><P>01/08/2014, Shoes, 21</P><P>01/08/2013, Shoes, 33</P><P>]; </P><P></P><P>Is there any suggestion for making this through the relational model at Qlikview?&nbsp; The final pivot must be dynamic; I mean, if the customer selects either Month, Quarter, Half-Year or Year we must get, from the current period, its previous MTD and YTD.</P><P></P><P>Does anyone who can help me on that? Thanks in advance, </P></BODY></HTML> Thu, 02 Apr 2015 21:37:53 GMT 2015-04-02T21:37:53Z Date Comparison Analysis https://community.qlik.com/t5/QlikView/Date-Comparison-Analysis/m-p/847118#M1017825 <HTML><HEAD></HEAD><BODY><P>Given the following Table, I need to compare the Quantity a Month, Quarter Half-Year and Year Ago plus the difference agaisnt YTD (same period of last calendar Year):</P><P></P><P>LOAD * INLINE</P><P>[Date, Product, Qty </P><P>08/01/2015, Shoes,&nbsp; 7</P><P>01/12/2014, Shoes, 10</P><P>01/12/2014, Shoes, 46</P><P>01/08/2014, Shoes, 21</P><P>01/08/2013, Shoes, 33</P><P>]; </P><P></P><P>Is there any suggestion for making this through the relational model at Qlikview?&nbsp; The final pivot must be dynamic; I mean, if the customer selects either Month, Quarter, Half-Year or Year we must get, from the current period, its previous MTD and YTD.</P><P></P><P>Does anyone who can help me on that? Thanks in advance, </P></BODY></HTML> Thu, 02 Apr 2015 21:37:53 GMT https://community.qlik.com/t5/QlikView/Date-Comparison-Analysis/m-p/847118#M1017825 2015-04-02T21:37:53Z Re: Date Comparison Analysis https://community.qlik.com/t5/QlikView/Date-Comparison-Analysis/m-p/847119#M1017826 <HTML><HEAD></HEAD><BODY><P>Perhaps this document helps: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Fri, 03 Apr 2015 12:32:51 GMT https://community.qlik.com/t5/QlikView/Date-Comparison-Analysis/m-p/847119#M1017826 Gysbert_Wassenaar 2015-04-03T12:32:51Z