topic Re: Display Ranked Columns as Rows and Group them in QlikView https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106705#M759098 <HTML><HEAD></HEAD><BODY><P>This is close enough. Is it possible to display the amount next to states such as</P><P>TX 7000 (same row with state and amount) instead of</P><P></P><P>TX</P><P>7000 ?</P></BODY></HTML> Fri, 07 Sep 2018 14:46:40 GMT newqlik2017 2018-09-07T14:46:40Z Display Ranked Columns as Rows and Group them https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106703#M759096 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>From my raw table (left table), I got top 5 states ranked based on the amount(right table).</P><P>Remaining states are categorized as others if they aren't top 5.</P><P></P><P>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?</P><P>Attached is the qvw for reference.</P><P></P><P><IMG alt="Ranking_Test2.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212955_Ranking_Test2.JPG" style="width: 620px; height: 188px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106703#M759096 newqlik2017 2020-11-25T16:16:04Z Re: Display Ranked Columns as Rows and Group them https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106704#M759097 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212983_Capture.PNG" style="height: 62px; width: 620px;" /></P></BODY></HTML> Fri, 07 Sep 2018 12:49:44 GMT https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106704#M759097 sunny_talwar 2018-09-07T12:49:44Z Re: Display Ranked Columns as Rows and Group them https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106705#M759098 <HTML><HEAD></HEAD><BODY><P>This is close enough. Is it possible to display the amount next to states such as</P><P>TX 7000 (same row with state and amount) instead of</P><P></P><P>TX</P><P>7000 ?</P></BODY></HTML> Fri, 07 Sep 2018 14:46:40 GMT https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106705#M759098 newqlik2017 2018-09-07T14:46:40Z Re: Display Ranked Columns as Rows and Group them https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106706#M759099 <HTML><HEAD></HEAD><BODY><P>This may be</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213003_Capture.PNG" style="height: 88px; width: 620px;" /></P></BODY></HTML> Fri, 07 Sep 2018 14:54:24 GMT https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106706#M759099 sunny_talwar 2018-09-07T14:54:24Z Re: Display Ranked Columns as Rows and Group them https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106707#M759100 <HTML><HEAD></HEAD><BODY><P>Thank you!!!</P></BODY></HTML> Fri, 07 Sep 2018 18:46:27 GMT https://community.qlik.com/t5/QlikView/Display-Ranked-Columns-as-Rows-and-Group-them/m-p/106707#M759100 newqlik2017 2018-09-07T18:46:27Z