topic Re: top 5 values in pivote table expressions in QlikView https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394175#M566478 <HTML><HEAD></HEAD><BODY><P>top 5 Employee count</P></BODY></HTML> Fri, 04 Jan 2013 12:20:11 GMT Qlik__Vinodh 2013-01-04T12:20:11Z top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394171#M566474 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have the dimensions like&nbsp; Region,Location,desigation for this i need the top 5 counts.</P><P></P><P>if any one having soluation pls let me know</P></BODY></HTML> Fri, 04 Jan 2013 11:37:58 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394171#M566474 Qlik__Vinodh 2013-01-04T11:37:58Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394172#M566475 <HTML><HEAD></HEAD><BODY><P>hi</P><P>what's you want in top 5</P></BODY></HTML> Fri, 04 Jan 2013 11:47:03 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394172#M566475 2013-01-04T11:47:03Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394173#M566476 <HTML><HEAD></HEAD><BODY><P>If u r using 11 version u have dimension limits tab, there u can select ur dimension on which u want to restrict, </P><P>u have differen options on that tab top, bottom, large.... like this</P></BODY></HTML> Fri, 04 Jan 2013 11:49:38 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394173#M566476 khadeer 2013-01-04T11:49:38Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394174#M566477 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can try this.</P><P></P><P><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">sum</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: maroon; background: white;">({&lt;Customer={"=</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">rank</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: maroon; background: white;">(sum(Sales))&lt;=$(=vTop)"}&gt;} Sales)</SPAN></P><P></P><P><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: maroon; background: white;">Where set <STRONG>vTop=5 </STRONG>in variable, so that it will give you correct result. In place of customer add ur dimension which u want.</SPAN></P><P></P><P><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: maroon; background: white;">Regards,</SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: maroon; background: white;">Nirav Bhimani<BR /></SPAN></P></BODY></HTML> Fri, 04 Jan 2013 11:50:41 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394174#M566477 nirav_bhimani 2013-01-04T11:50:41Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394175#M566478 <HTML><HEAD></HEAD><BODY><P>top 5 Employee count</P></BODY></HTML> Fri, 04 Jan 2013 12:20:11 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394175#M566478 Qlik__Vinodh 2013-01-04T12:20:11Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394176#M566479 <HTML><HEAD></HEAD><BODY><P>top 5 employee </P></BODY></HTML> Fri, 04 Jan 2013 12:20:41 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394176#M566479 Qlik__Vinodh 2013-01-04T12:20:41Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394177#M566480 <HTML><HEAD></HEAD><BODY><P>hear i am having more dimensions in pivote table.......</P></BODY></HTML> Fri, 04 Jan 2013 12:22:25 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394177#M566480 Qlik__Vinodh 2013-01-04T12:22:25Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394178#M566481 <HTML><HEAD></HEAD><BODY><P>location and year wise top 5 Employee count&nbsp; ...............required pls help me out this</P></BODY></HTML> Fri, 04 Jan 2013 12:38:58 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394178#M566481 Qlik__Vinodh 2013-01-04T12:38:58Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394179#M566482 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I need the Count of Employee-id is the top 1 values.</P><P></P><P>year,location,desigation ,&nbsp; Count(Empid)[Expression]</P><P></P><P>&nbsp; 2012,dd,dsddf,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P></P><P></P><P>like wise i need for each and every year,Location and desigarion wise need yar .please help me out.</P></BODY></HTML> Sat, 05 Jan 2013 07:07:17 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394179#M566482 Qlik__Vinodh 2013-01-05T07:07:17Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394180#M566483 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>Try this,</P><P></P><P><SPAN style="background-color: #ffffff; font-size: 12pt; font-family: 'Times New Roman', serif; color: blue;">AGGR ( sum</SPAN><SPAN style="background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; color: maroon;">({&lt;Customer={"=</SPAN><SPAN style="background-color: #ffffff; font-size: 12pt; font-family: 'Times New Roman', serif; color: blue;">rank</SPAN><SPAN style="background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; color: maroon;">(sum(Sales))&lt;=$(=vTop)"}&gt;} Sales), <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">year,location,desigation</SPAN>)</SPAN></P><P></P><P>Regards,</P><P>Nirav Bhimani</P></BODY></HTML> Sat, 05 Jan 2013 07:32:11 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394180#M566483 nirav_bhimani 2013-01-05T07:32:11Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394181#M566484 <HTML><HEAD></HEAD><BODY><P>I need the top 5 high count value . not sume values. yar.</P></BODY></HTML> Sat, 05 Jan 2013 08:08:31 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394181#M566484 Qlik__Vinodh 2013-01-05T08:08:31Z Re: top 5 values in pivote table expressions https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394182#M566485 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this expression</P><P></P><P><SPAN style="background-color: #ffffff; font-size: 12pt; font-family: 'Times New Roman', serif; color: blue;">=If(AGGR (</SPAN><SPAN style="background-color: #ffffff; font-size: 12pt; font-family: 'Times New Roman', serif; color: blue;">rank</SPAN><SPAN style="background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; color: maroon;">(sum(Sales)), Customer) &lt;=5 , Customer)</SPAN></P><P></P><P><SPAN style="background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; color: maroon;">in dimension.</SPAN></P><P></P><P><SPAN style="background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; color: maroon;">Regards,</SPAN></P><P><SPAN style="background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; color: maroon;">Jagan.<BR /></SPAN></P></BODY></HTML> Sat, 05 Jan 2013 08:25:01 GMT https://community.qlik.com/t5/QlikView/top-5-values-in-pivote-table-expressions/m-p/394182#M566485 jagan 2013-01-05T08:25:01Z