Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a pivot table which restricts to the top 5 clients by sales for current year. I want to show the client's rank from the previous year but not within the same group of 5 clients.
It is ranking the group of 5 clients for the previous year.
I want to see the rank the this year's top 5 over the entire set of all clients from the previous year. If the client didn't exist in the previous year the label as a new client.