topic Re: Year to year analysis in QlikView https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702326#M673231 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd">http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd</A></P></BODY></HTML> Tue, 19 Aug 2014 08:00:24 GMT MK_QSL 2014-08-19T08:00:24Z Year to year analysis https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702325#M673229 <HTML><HEAD></HEAD><BODY><P>Hi All </P><P></P><P>Can anyone tell me how can i do a year to year , month to month analysis</P></BODY></HTML> Tue, 19 Aug 2014 07:56:26 GMT https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702325#M673229 2014-08-19T07:56:26Z Re: Year to year analysis https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702326#M673231 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd">http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd</A></P></BODY></HTML> Tue, 19 Aug 2014 08:00:24 GMT https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702326#M673231 MK_QSL 2014-08-19T08:00:24Z Re: Year to year analysis https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702327#M673232 <HTML><HEAD></HEAD><BODY><P>Have a look here:<A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd"> Year Over Year Comparison</A></P></BODY></HTML> Tue, 19 Aug 2014 08:01:27 GMT https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702327#M673232 tresB 2014-08-19T08:01:27Z Re: Year to year analysis https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702328#M673233 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>have&nbsp; a look at below post.</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6163">http://community.qlik.com/docs/DOC-6163</A></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 19 Aug 2014 08:03:36 GMT https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702328#M673233 ashfaq_haseeb 2014-08-19T08:03:36Z Re: Year to year analysis https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702329#M673234 <HTML><HEAD></HEAD><BODY><P>i wanted&nbsp; to know how show last year and current year variance in qlikiview</P></BODY></HTML> Tue, 19 Aug 2014 08:48:52 GMT https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702329#M673234 2014-08-19T08:48:52Z Re: Year to year analysis https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702330#M673235 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In that case below expressions must work.</P><P></P><P><STRONG>Current Year Sales</STRONG></P><P> =Sum({&lt;Year = {'$(=Max(Year))'}&gt;} Sales)</P><P></P><P></P><P><STRONG>Previous Year Sales</STRONG></P><P> =Sum({&lt;Year = {'$(=Max(Year)-1)'}&gt;} Sales)</P><P></P><P></P><P>Modify them accordingly </P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 19 Aug 2014 08:53:16 GMT https://community.qlik.com/t5/QlikView/Year-to-year-analysis/m-p/702330#M673235 ashfaq_haseeb 2014-08-19T08:53:16Z