Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
newqlik2017
Contributor

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

Re: Display Ranked Columns as Rows and Group them

This?

Capture.PNG

newqlik2017
Contributor

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 ?

Re: Display Ranked Columns as Rows and Group them

This may be

Capture.PNG

newqlik2017
Contributor

Re: Display Ranked Columns as Rows and Group them

Thank you!!!