Discussion board where members can get started with QlikView.
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.
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
This may be