Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

Display Ranked Columns as Rows and Group them

Hello,

From my raw table (left table), I got top 5 states ranked based on the amount(right table).

Remaining states are categorized as others if they aren't top 5.

Now, this needs to be converted into a row with top 5 states and their amount followed by Other, which is the sum of all remaining states. Any ideas?

Attached is the qvw for reference.

Ranking_Test2.JPG

4 Replies
sunny_talwar

This?

Capture.PNG

newqlik2017
Creator II
Creator II
Author

This is close enough. Is it possible to display the amount next to states such as

TX 7000 (same row with state and amount) instead of

TX

7000 ?

sunny_talwar

This may be

Capture.PNG

newqlik2017
Creator II
Creator II
Author

Thank you!!!