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

I need help displaying new contacts for each year on a pivot table. Below is a picture of what I have so far. I need each contact to show only once and that is when it was first created. What I have now shows the contact name for each year it was contacted but I would like it to show for only the year it was created. Thanks for suggestions

 

 

DD1.pngDD2.png

2 Replies
Anil_Babu_Samineni

If i understand correctly, just do like this?

FirstSortedValue([Contact Name], -[Contact Year], 1)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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 created.