Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Display New customers Year on Year

Hi Everyone  ...

I want to display newly added customers yearly 

Like in 2017 having c1,c2  .. Likewise in 2018 having c1,c2,c3  ... Now in 2018 c3 will be considered as new customer.

Please find the attached screen for details 

Can someone let me know the chart expression for this approach.

 

Thanks

Sai. 

 

Screenshot_20191203_153618.png

 

Labels (1)
1 Solution

Accepted Solutions
miskinmaz
Creator III
Creator III

New: count({<CLIENTID=E({<YYEAR={'<$(=max(YYEAR))'}>}CLIENTID)>} distinct CLIENTID)

Referred from https://community.qlik.com/t5/QlikView-App-Development/New-Lost-Returning-Loyal-Customers/td-p/98152...

You need to modify the filed names

View solution in original post

1 Reply
miskinmaz
Creator III
Creator III

New: count({<CLIENTID=E({<YYEAR={'<$(=max(YYEAR))'}>}CLIENTID)>} distinct CLIENTID)

Referred from https://community.qlik.com/t5/QlikView-App-Development/New-Lost-Returning-Loyal-Customers/td-p/98152...

You need to modify the filed names