Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

 

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Display New customers Year on Year

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
Highlighted
Creator III
Creator III

Re: Display New customers Year on Year

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