topic Re: Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/91174#M766458 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum({&lt;Customer = p({&lt;Year = {$(=Max(Year))}&gt;})*p({&lt;Year = {$(=Max(Year)-1)}&gt;})&gt;}Sales)</STRONG></P></BODY></HTML> Thu, 28 Jun 2018 14:28:12 GMT sunny_talwar 2018-06-28T14:28:12Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/91173#M766457 <HTML><HEAD></HEAD><BODY><P>I have below data and i want to display customer name those having Sales for max year as well as previous year.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD class="xl63" height="20" width="64">Year</TD><TD class="xl63" style="border-left: none;" width="64">Customer</TD><TD class="xl63" style="border-left: none;" width="64">Sales</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2018</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2018</TD><TD class="xl63" style="border-top: none; border-left: none;">B</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2017</TD><TD class="xl63" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2016</TD><TD class="xl63" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">40</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">20016</TD><TD class="xl63" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD></TR></TBODY></TABLE><P></P><P>Regards,</P><P>Villyee </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/91173#M766457 vanderson009 2020-11-25T16:16:04Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/91174#M766458 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum({&lt;Customer = p({&lt;Year = {$(=Max(Year))}&gt;})*p({&lt;Year = {$(=Max(Year)-1)}&gt;})&gt;}Sales)</STRONG></P></BODY></HTML> Thu, 28 Jun 2018 14:28:12 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/91174#M766458 sunny_talwar 2018-06-28T14:28:12Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/91175#M766459 <HTML><HEAD></HEAD><BODY><P>your gr8 <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P></BODY></HTML> Thu, 28 Jun 2018 14:45:17 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/91175#M766459 vanderson009 2018-06-28T14:45:17Z