Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Top 5 chart showing Rank in two periods

Hi,

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.

Currently:

It is ranking the group of 5 clients for the previous year.

currentproblem.JPG

Solution

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.

solution.JPG

Labels (4)
0 Replies