Qlik Community

App Development

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

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Tracking sales for new vs returning customers in any given year

I have sales data (customer, acct no, transx date, etc.) that has a simple field for the year a client started working with my company.  I would like to compare the share of our sales in any given year that came from new customers vs returning customers.

I've been able to get as far as an expression that breaks out the sales for clients whose entry year = the Max Year in the sales data vs less than the Max Year, but it doesn't work for past years.  How can I use my data to get that reporting? 

0 Replies