Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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