topic Re: Set Analysis in App Development https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61409#M4035 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum({&lt;ProductName = {"$(=FirstSortedValue(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">{&lt;ProductName = e({&lt;Year = {$(=Max(Year) - 1)}&gt;})&gt;}</SPAN>ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}&gt;}sales)</STRONG></P></BODY></HTML> Tue, 06 Feb 2018 20:13:41 GMT sunny_talwar 2018-02-06T20:13:41Z Set Analysis https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61408#M4034 <HTML><HEAD></HEAD><BODY><P><SPAN style="display: inline !important; float: none; background-color: transparent; color: #3d3d3d; font-family: 'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">I will have to do that. I'm trying do a comparison of products, where I need to find my most sold product that wasn't sell the previous year.</SPAN></P></BODY></HTML> Tue, 06 Feb 2018 20:10:35 GMT https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61408#M4034 Anonymous 2018-02-06T20:10:35Z Re: Set Analysis https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61409#M4035 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum({&lt;ProductName = {"$(=FirstSortedValue(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">{&lt;ProductName = e({&lt;Year = {$(=Max(Year) - 1)}&gt;})&gt;}</SPAN>ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}&gt;}sales)</STRONG></P></BODY></HTML> Tue, 06 Feb 2018 20:13:41 GMT https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61409#M4035 sunny_talwar 2018-02-06T20:13:41Z Re: Set Analysis https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61410#M4036 <HTML><HEAD></HEAD><BODY><P>Do you know something about DAX?? </P></BODY></HTML> Tue, 06 Feb 2018 20:18:38 GMT https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61410#M4036 Anonymous 2018-02-06T20:18:38Z Re: Set Analysis https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61411#M4037 <HTML><HEAD></HEAD><BODY><P>DAX? Not sure what that is?</P></BODY></HTML> Tue, 06 Feb 2018 20:22:41 GMT https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61411#M4037 sunny_talwar 2018-02-06T20:22:41Z Re: Set Analysis https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61412#M4038 <HTML><HEAD></HEAD><BODY><P>A programming language for Power BI</P></BODY></HTML> Tue, 06 Feb 2018 20:23:47 GMT https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61412#M4038 Anonymous 2018-02-06T20:23:47Z Re: Set Analysis https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61413#M4039 <HTML><HEAD></HEAD><BODY><P>Nope, no idea sorry</P></BODY></HTML> Tue, 06 Feb 2018 20:24:28 GMT https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61413#M4039 sunny_talwar 2018-02-06T20:24:28Z Re: Set Analysis https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61414#M4040 <HTML><HEAD></HEAD><BODY><P>Ok, thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /> for all </P></BODY></HTML> Tue, 06 Feb 2018 20:25:18 GMT https://community.qlik.com/t5/App-Development/Set-Analysis/m-p/61414#M4040 Anonymous 2018-02-06T20:25:18Z