topic Re: help required for set analysis in QlikView https://community.qlik.com/t5/QlikView/help-required-for-set-analysis/m-p/435791#M487675 <HTML><HEAD></HEAD><BODY><P>Do you need something like:</P><P></P><P>sum({&lt;Year={'$(=Min(Year)-1'},Month={'$(=Min(Month)'}&gt;} [GROSS SALES AMOUNT])</P><P></P><P>Jonathan</P></BODY></HTML> Fri, 15 Feb 2013 12:53:17 GMT Anonymous 2013-02-15T12:53:17Z help required for set analysis https://community.qlik.com/t5/QlikView/help-required-for-set-analysis/m-p/435790#M487674 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>I have attached screen short for my report requirement is that when i Select&nbsp; May/Jun 2012 month for current Financial year&nbsp; then in last year I have show May/jun 2011.</P><P></P><P>How we have to write set analysis.</P><P></P><P>Thanks in advance</P><P></P><P>Vikas</P><P></P><P>Please note&nbsp; my variables is&nbsp; GROSS SALES AMT&nbsp; and fiscalyear&nbsp; and month no</P></BODY></HTML> Thu, 14 Feb 2013 09:30:39 GMT https://community.qlik.com/t5/QlikView/help-required-for-set-analysis/m-p/435790#M487674 vikasmahajan 2013-02-14T09:30:39Z Re: help required for set analysis https://community.qlik.com/t5/QlikView/help-required-for-set-analysis/m-p/435791#M487675 <HTML><HEAD></HEAD><BODY><P>Do you need something like:</P><P></P><P>sum({&lt;Year={'$(=Min(Year)-1'},Month={'$(=Min(Month)'}&gt;} [GROSS SALES AMOUNT])</P><P></P><P>Jonathan</P></BODY></HTML> Fri, 15 Feb 2013 12:53:17 GMT https://community.qlik.com/t5/QlikView/help-required-for-set-analysis/m-p/435791#M487675 Anonymous 2013-02-15T12:53:17Z