topic Re: Top 10 using an expression in QlikView https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876962#M306243 <HTML><HEAD></HEAD><BODY><P>Not in the same expression.</P></BODY></HTML> Thu, 11 Jun 2015 14:52:22 GMT 2015-06-11T14:52:22Z Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876953#M306234 <HTML><HEAD></HEAD><BODY><P>I have created a pivot table with one dimension and multiple expressions.&nbsp; I need to create 2 more tables using the same information but I only want to pull the top 10 and the top 10 bottom based on one of the expressions.</P><P></P><P>Here is what the expression looks like:</P><P>if (sum({&lt;FYEAR={$(vBenchYr)},QUARTER={'Q4'}&gt;}(SALES_OVR))&lt;&gt;0,</P><P>1-((sum({&lt;FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}&gt;}(SALES_TOTAL))/sum({&lt;FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}&gt;}(QTY))*Column(3)) /</P><P>((sum({&lt;FYEAR={$(vBenchYr)},QUARTER={'Q4'}&gt;}(SALES_OVR))/sum({&lt;FYEAR={$(vBenchYr)},QUARTER={'Q4'}&gt;}(QTY_OVR)))*Column(3))),</P><P></P><P>1-((sum({&lt;FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}&gt;}(SALES_TOTAL))/sum({&lt;FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}&gt;}(QTY))*Column(3)) /</P><P>((sum({&lt;FYEAR={$(vBenchYr)},QUARTER={'Q4'}&gt;}(SALES_TOTAL))/sum({&lt;FYEAR={$(vBenchYr)},QUARTER={'Q4'}&gt;}(QTY)))*Column(3))))</P><P></P><P>Is there a way to only pull the top 10 &amp; bottom 10 based on the value from this????</P></BODY></HTML> Thu, 11 Jun 2015 14:22:38 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876953#M306234 2015-06-11T14:22:38Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876954#M306235 <HTML><HEAD></HEAD><BODY><P>Dimension limits</P></BODY></HTML> Thu, 11 Jun 2015 14:28:13 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876954#M306235 giakoum 2015-06-11T14:28:13Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876955#M306236 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89132_Capture.PNG" style="height: 220px; width: 620px;" /></P></BODY></HTML> Thu, 11 Jun 2015 14:29:46 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876955#M306236 giakoum 2015-06-11T14:29:46Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876956#M306237 <HTML><HEAD></HEAD><BODY><P>It is an expression that I am trying to use &amp; not a dimension.</P></BODY></HTML> Thu, 11 Jun 2015 14:31:34 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876956#M306237 2015-06-11T14:31:34Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876957#M306238 <HTML><HEAD></HEAD><BODY><P>this shows the dimensions that correspond to the top 10 expression values</P><P>largest 10 values means largest 10 expression values </P></BODY></HTML> Thu, 11 Jun 2015 14:33:59 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876957#M306238 giakoum 2015-06-11T14:33:59Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876958#M306239 <HTML><HEAD></HEAD><BODY><P>How do I get this tab to show???? I don't see dimension limits tab </P></BODY></HTML> Thu, 11 Jun 2015 14:37:14 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876958#M306239 2015-06-11T14:37:14Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876959#M306240 <HTML><HEAD></HEAD><BODY><P>what chart type do you use? it is not available for all</P></BODY></HTML> Thu, 11 Jun 2015 14:39:23 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876959#M306240 giakoum 2015-06-11T14:39:23Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876960#M306241 <HTML><HEAD></HEAD><BODY><P>Pivot table and also my dimension is set up as a group</P></BODY></HTML> Thu, 11 Jun 2015 14:40:58 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876960#M306241 2015-06-11T14:40:58Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876961#M306242 <HTML><HEAD></HEAD><BODY><P>do you want the top 10 and min 10 inside of the same expression ?</P></BODY></HTML> Thu, 11 Jun 2015 14:50:18 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876961#M306242 ramoncova06 2015-06-11T14:50:18Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876962#M306243 <HTML><HEAD></HEAD><BODY><P>Not in the same expression.</P></BODY></HTML> Thu, 11 Jun 2015 14:52:22 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876962#M306243 2015-06-11T14:52:22Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876963#M306244 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">Aggr</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">If</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">rank</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">Sum</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: maroon;">sales_total</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">))&gt;=10,</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: maroon;">FYEAR</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">),</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: maroon;">FYEAR</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">) </SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">Aggr</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">If</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">rank</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: blue;">Sum</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: maroon;">sales_total</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">))&lt;=10,</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: maroon;">FYEAR</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">),</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: maroon;">FYEAR</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: black;">) </SPAN></SPAN></P></BODY></HTML> Thu, 11 Jun 2015 15:09:01 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876963#M306244 pratap6699 2015-06-11T15:09:01Z Re: Top 10 using an expression https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876964#M306245 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/157792">Customers Having Top 4 Values</A>‌</P><P>that post has several methods of doing the top 4 that you could apply for the top 10, for the lowest 10, you might need to use an aggr with a min</P><P></P><P>expression &gt; (aggr(min(expresion,10),field)</P></BODY></HTML> Thu, 11 Jun 2015 15:28:18 GMT https://community.qlik.com/t5/QlikView/Top-10-using-an-expression/m-p/876964#M306245 ramoncova06 2015-06-11T15:28:18Z