Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
isanbaeva
Contributor
Contributor

amount of new sales per customer

Hi, everybody!

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. 

 I have:

customers, date of sale, product.

How I may solve it not in boot script?

 

Thank you, 

Elena Isanbaeva.

Labels (1)
2 Replies
Susan_DS
Partner - Contributor III
Partner - Contributor III

Hi, Elena,

 

Perhaps something like this: 

Count(product*if(date of sale = aggr(nodistinct max(date of sale),customers),1,0)

MarcoWedel

How do you calculate the count of new sales per customer monthly?
Please post some sample data and your expected result.
thanks