Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Year over year

Hello everyone. I need help finding out new accounts created each year from 2014 to date.  The set expression below is what I have but it brings up nothing. I need to get the number of new accounts created  each year. Thanks

Count({<[Contact Created Date]={$(Year(Today()))}>}[Contact ID])

3 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

Can u please elaborate if in which visualization like a table , KPI, etc

If you want in the table take dimension as Year([Contact Created Date])

and for Measure Count([Contact ID])

Hope this helps

Thanks

Thanks and Regards
Kashyap.R
Pomna
Creator III
Creator III
Author

Thanks for your reply but its not giving me what I want. I need values in each year to be unique. That is, a contact name should appear only once and that is on the year the contact was first created.

Pomna
Creator III
Creator III
Author

Hello everyone thanks for the suggestions but this is what worked for me. For dimension I used

Contact Name 

and measure

MinString([Contact Year]) as measure

This gives me the account name and first year it was contacted which is the year it was created