topic Re: How to find last 3 Sales of the customer when entering the Customer ID in QlikView https://community.qlik.com/t5/QlikView/How-to-find-last-3-Sales-of-the-customer-when-entering-the/m-p/1373819#M419563 <HTML><HEAD></HEAD><BODY><P>When you say entered, do you mean when you select a particular customer id?</P><P></P><P>May be this:</P><P><STRONG style="font-size: 10pt;">Sum({&lt;Date = {"$(='&gt;=' &amp; Date(Max(Date, 3), 'DD.MM.YYYY'))"}&gt;}Sales)</STRONG></P></BODY></HTML> Fri, 08 Dec 2017 14:19:58 GMT sunny_talwar 2017-12-08T14:19:58Z How to find last 3 Sales of the customer when entering the Customer ID https://community.qlik.com/t5/QlikView/How-to-find-last-3-Sales-of-the-customer-when-entering-the/m-p/1373818#M419562 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can anyone help on this? </P><P>How to find last 3 sales of the customer once i enter the customer id?</P><P>Example: Entered Customer Id is A202.</P><P>I need last his sales</P><P>100+200+300 =700.</P><P>How to solve this? Thanks in advance</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>customer ID</STRONG></TH></TR><TR><TD style="padding: 2px;">27.10.2017</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">&nbsp; A202</TD></TR><TR><TD style="padding: 2px;">30.10.2017</TD><TD style="padding: 2px;">633</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">A202</SPAN></TD></TR><TR><TD style="padding: 2px;">02.10.2017</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">A202</SPAN></TD></TR><TR><TD style="padding: 2px;">06.10.2017</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">A202</SPAN></TD></TR><TR><TD style="padding: 2px;">25.11.2017</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">A202</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 08 Dec 2017 14:18:19 GMT https://community.qlik.com/t5/QlikView/How-to-find-last-3-Sales-of-the-customer-when-entering-the/m-p/1373818#M419562 rkpatelqlikview 2017-12-08T14:18:19Z Re: How to find last 3 Sales of the customer when entering the Customer ID https://community.qlik.com/t5/QlikView/How-to-find-last-3-Sales-of-the-customer-when-entering-the/m-p/1373819#M419563 <HTML><HEAD></HEAD><BODY><P>When you say entered, do you mean when you select a particular customer id?</P><P></P><P>May be this:</P><P><STRONG style="font-size: 10pt;">Sum({&lt;Date = {"$(='&gt;=' &amp; Date(Max(Date, 3), 'DD.MM.YYYY'))"}&gt;}Sales)</STRONG></P></BODY></HTML> Fri, 08 Dec 2017 14:19:58 GMT https://community.qlik.com/t5/QlikView/How-to-find-last-3-Sales-of-the-customer-when-entering-the/m-p/1373819#M419563 sunny_talwar 2017-12-08T14:19:58Z Re: How to find last 3 Sales of the customer when entering the Customer ID https://community.qlik.com/t5/QlikView/How-to-find-last-3-Sales-of-the-customer-when-entering-the/m-p/1373820#M419564 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Fri, 08 Dec 2017 14:32:08 GMT https://community.qlik.com/t5/QlikView/How-to-find-last-3-Sales-of-the-customer-when-entering-the/m-p/1373820#M419564 rkpatelqlikview 2017-12-08T14:32:08Z