topic Re: How to display 1st 5 greater Element in a File in QlikView https://community.qlik.com/t5/QlikView/How-to-display-1st-5-greater-Element-in-a-File/m-p/885923#M1009884 <HTML><HEAD></HEAD><BODY><P>If you only want to display the top 5 Dimensions in say a chart or table you can use Dimension Limits in the object properties.</P><P>If you only want to load the top five from datasource you will have to handle that differently.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85777_Capture.PNG" style="width: 620px; height: 552px;" /></P></BODY></HTML> Wed, 06 May 2015 13:08:26 GMT Anonymous 2015-05-06T13:08:26Z How to display 1st 5 greater Element in a File https://community.qlik.com/t5/QlikView/How-to-display-1st-5-greater-Element-in-a-File/m-p/885922#M1009882 <HTML><HEAD></HEAD><BODY><P>Example</P><P></P><P>DIm1</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P>Dimention</P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P>Qnty</P></TH></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">DEF</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">HIJ</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">KLM</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">NOP</TD><TD style="padding: 2px;">27</TD></TR><TR><TD style="padding: 2px;">QRS</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">TUV</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">WXY</TD><TD style="padding: 2px;">20</TD></TR></TBODY></TABLE><P></P><P>Output Should be</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Dimention</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Qty</TH></TR><TR><TD style="padding: 2px;">QRS</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">NOP</TD><TD style="padding: 2px;">27</TD></TR><TR><TD style="padding: 2px;">WXY</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">TUV</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">HIJ</TD><TD style="padding: 2px;">15</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 06 May 2015 09:44:56 GMT https://community.qlik.com/t5/QlikView/How-to-display-1st-5-greater-Element-in-a-File/m-p/885922#M1009882 2015-05-06T09:44:56Z Re: How to display 1st 5 greater Element in a File https://community.qlik.com/t5/QlikView/How-to-display-1st-5-greater-Element-in-a-File/m-p/885923#M1009884 <HTML><HEAD></HEAD><BODY><P>If you only want to display the top 5 Dimensions in say a chart or table you can use Dimension Limits in the object properties.</P><P>If you only want to load the top five from datasource you will have to handle that differently.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85777_Capture.PNG" style="width: 620px; height: 552px;" /></P></BODY></HTML> Wed, 06 May 2015 13:08:26 GMT https://community.qlik.com/t5/QlikView/How-to-display-1st-5-greater-Element-in-a-File/m-p/885923#M1009884 Anonymous 2015-05-06T13:08:26Z Re: How to display 1st 5 greater Element in a File https://community.qlik.com/t5/QlikView/How-to-display-1st-5-greater-Element-in-a-File/m-p/885924#M1009887 <HTML><HEAD></HEAD><BODY><P>Thank's for Helping,,&nbsp; is there is any option forTable Box</P></BODY></HTML> Thu, 07 May 2015 09:11:24 GMT https://community.qlik.com/t5/QlikView/How-to-display-1st-5-greater-Element-in-a-File/m-p/885924#M1009887 2015-05-07T09:11:24Z