topic Re: set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/482471#M551738 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this using P() in set analysis </P><P></P><P>=Sum({&lt;Year={$(=Year(Today()))}, SalesExecutive=P({1&lt;Year={$(=(Year(Today()) - 1))}&gt;})&gt;}&nbsp; Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Sat, 23 Nov 2013 16:45:25 GMT jagan 2013-11-23T16:45:25Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/482468#M551735 <HTML><HEAD></HEAD><BODY><P>I have a requirement that need to get current year values for previous year sales executives only</P><P>how to get it by set analysis?</P></BODY></HTML> Sat, 23 Nov 2013 14:15:11 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/482468#M551735 2013-11-23T14:15:11Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/482469#M551736 <HTML><HEAD></HEAD><BODY><P>Could you give an example.</P><P>What fields are there to identify previous year sales executives?</P><P>Please post a sample application.</P></BODY></HTML> Sat, 23 Nov 2013 14:32:58 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/482469#M551736 anandathome 2013-11-23T14:32:58Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/482470#M551737 <HTML><HEAD></HEAD><BODY><P>Could you please explain your requirements? if possible, please some sample data or file for better understanding.</P></BODY></HTML> Sat, 23 Nov 2013 15:32:23 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/482470#M551737 MK_QSL 2013-11-23T15:32:23Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/482471#M551738 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this using P() in set analysis </P><P></P><P>=Sum({&lt;Year={$(=Year(Today()))}, SalesExecutive=P({1&lt;Year={$(=(Year(Today()) - 1))}&gt;})&gt;}&nbsp; Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Sat, 23 Nov 2013 16:45:25 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/482471#M551738 jagan 2013-11-23T16:45:25Z