Display New customers Year on Year

[kakani87]

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. 

[miskinmaz · Accepted solution]

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