topic Top Values in QlikView https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159198#M889628 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am attempting to get top values based on my current selections and anything that is not a current selection should be rolled up into "Other".</P><P></P><P>For Example:</P><P></P><P>I have</P><P></P><P>Fruit:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count:</P><P>Apple&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>Pear&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>Orange&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>Mango&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 </P><P></P><P>If I select Apple and Orange, I would expect Pear and Mango to roll up into "Other".</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Top Values https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159198#M889628 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am attempting to get top values based on my current selections and anything that is not a current selection should be rolled up into "Other".</P><P></P><P>For Example:</P><P></P><P>I have</P><P></P><P>Fruit:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count:</P><P>Apple&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>Pear&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>Orange&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>Mango&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 </P><P></P><P>If I select Apple and Orange, I would expect Pear and Mango to roll up into "Other".</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159198#M889628 2020-11-25T16:16:04Z Re: Top Values https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159199#M889629 <HTML><HEAD></HEAD><BODY><P>Check the attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135355_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 23 Aug 2016 21:52:41 GMT https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159199#M889629 sunny_talwar 2016-08-23T21:52:41Z Re: Top Values https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159200#M889630 <HTML><HEAD></HEAD><BODY><P>This is not working for me.&nbsp; How can I send my QVW without sending the sensitive information?</P></BODY></HTML> Tue, 23 Aug 2016 23:01:28 GMT https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159200#M889630 2016-08-23T23:01:28Z Re: Top Values https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159201#M889631 <HTML><HEAD></HEAD><BODY><P>Check this:</P><P><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Wed, 24 Aug 2016 00:46:39 GMT https://community.qlik.com/t5/QlikView/Top-Values/m-p/1159201#M889631 sunny_talwar 2016-08-24T00:46:39Z