https://community.qlik.com/t5/App-Development/amount-of-new-sales-per-customer/m-p/1943032#M77705 <P>Hi, Elena,</P> <P>&nbsp;</P> <P>Perhaps something like this:&nbsp;</P> <P>Count(product*if(date of sale = aggr(nodistinct max(date of sale),customers),1,0)</P> Mon, 13 Jun 2022 18:58:48 GMT Susan_DS 2022-06-13T18:58:48Z https://community.qlik.com/t5/App-Development/amount-of-new-sales-per-customer/m-p/1942947#M77698 <P>Hi, everybody!</P> <P>I have an issue - I want to count only new sales per customer monthly. I tried to use function Firstsortedvalue, but it seems doesnt work correctly.&nbsp;</P> <P>&nbsp;I have:</P> <P>customers, date of sale, product.</P> <P>How I may solve it&nbsp;not in boot script?</P> <P>&nbsp;</P> <P>Thank you,&nbsp;</P> <P>Elena Isanbaeva.</P> Mon, 13 Jun 2022 14:58:25 GMT https://community.qlik.com/t5/App-Development/amount-of-new-sales-per-customer/m-p/1942947#M77698 isanbaeva 2022-06-13T14:58:25Z https://community.qlik.com/t5/App-Development/amount-of-new-sales-per-customer/m-p/1943032#M77705 <P>Hi, Elena,</P> <P>&nbsp;</P> <P>Perhaps something like this:&nbsp;</P> <P>Count(product*if(date of sale = aggr(nodistinct max(date of sale),customers),1,0)</P> Mon, 13 Jun 2022 18:58:48 GMT https://community.qlik.com/t5/App-Development/amount-of-new-sales-per-customer/m-p/1943032#M77705 Susan_DS 2022-06-13T18:58:48Z https://community.qlik.com/t5/App-Development/amount-of-new-sales-per-customer/m-p/1943051#M77708 <P>How do you calculate the&nbsp;<SPAN>count of new sales per customer monthly?<BR />Please post some sample data and your expected result.<BR />thanks<BR /><BR /></SPAN></P> Mon, 13 Jun 2022 19:47:54 GMT https://community.qlik.com/t5/App-Development/amount-of-new-sales-per-customer/m-p/1943051#M77708 MarcoWedel 2022-06-13T19:47:54Z