Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

Re: Display Ranked Columns as Rows and Group them

This?

Capture.PNG

Highlighted
Creator
Creator

Re: Display Ranked Columns as Rows and Group them

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 ?

Highlighted

Re: Display Ranked Columns as Rows and Group them

This may be

Capture.PNG

Highlighted
Creator
Creator

Re: Display Ranked Columns as Rows and Group them

Thank you!!!