This content has been marked as final. Show 6 replies
I am trying to show a line chart or a bar chart representing the last time an user ID is present in the database.
With the following table :
I want the values of my chart to be 1 for 2014, 1 for 2015 and 2 for 2017.
This thread Count Distinct Accumulation in Qlik Sense helped me a lot but I still don't know how to use the last occurrence instead of the first for a distinct count.