Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

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




2 Replies

If i understand correctly, just do like this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator II
Creator II

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.