https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195582#M56022 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I saw your file, but there isn't clear what are you expecting, I mean, If you want a Top 10 for every column, maybe a Branch could be in a top 10 of the first column but not in the second one.</P><P>If you check out my example file, the Branch CHANDIGARH is top 11-12 for the first column, 8 for the second one and 12 for the third, so what will you show in this case?</P><P>Regards.</P></BODY></HTML> Thu, 09 Sep 2010 13:07:33 GMT 2010-09-09T13:07:33Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195577#M56017 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Can Any One help me to apply Top or First Function to this QV Doccument.</P><P>I need all coloumns TOP Ten (10) Records in Case of FileNo ,In case of Amount no ,at every coloumn...</P><P>I sending doccument attached .......</P><P></P><P>Its very urgent</P><P></P><P>Thanx in advance</P><P></P><P>Mail me @ ......... <A href="mailto:dushyant@iconresources.com">dushyant@iconresources.com</A> or <A href="mailto:dushyant.ntpc@gmail.com">dushyant.ntpc@gmail.com</A></P><P></P></BODY></HTML> Thu, 09 Sep 2010 12:40:43 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195577#M56017 2010-09-09T12:40:43Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195578#M56018 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could you attach a file showing what are you expecting?</P><P>Regards.</P><P></P></BODY></HTML> Thu, 09 Sep 2010 12:49:47 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195578#M56018 2010-09-09T12:49:47Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195579#M56019 <HTML><HEAD></HEAD><BODY><P>Dear Gallego,</P><P>Please find out the attched doccument at which i want top 10 value in every coloumn of the streight table......</P><P></P></BODY></HTML> Thu, 09 Sep 2010 12:53:08 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195579#M56019 2010-09-09T12:53:08Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195580#M56020 <HTML><HEAD></HEAD><BODY><DIV class="CommonCommentArrow"><DIV class="r1"></DIV><DIV class="r2"></DIV><DIV class="r3"></DIV><DIV class="r4"></DIV><DIV class="r5"></DIV><DIV class="r6"></DIV><DIV class="r7"></DIV><DIV class="r8"></DIV><DIV class="r9"></DIV><DIV class="r10"></DIV></DIV><DIV class="CommonCommentBubble"><DIV class="CommonCommentBubbleRoundTop"><DIV class="r1"></DIV><DIV class="r2"></DIV><DIV class="r3"></DIV><DIV class="r4"></DIV></DIV><DIV class="CommonCommentContent ForumReplyToPostArea" style="overflow:hidden;width:100%;"><P>Dear Gallego,</P><P>Please find out the attched doccument at which i want top 10 value in every coloumn of the streight table......</P></DIV></DIV></BODY></HTML> Thu, 09 Sep 2010 12:57:24 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195580#M56020 2010-09-09T12:57:24Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195581#M56021 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>"I need all coloumns TOP Ten (10) Records in Case of FileNo ,In case of Amount no ,at every coloumn..."....this line from your post is not giving a clear idea of what you want. an elaboration could help.</P></BODY></HTML> Thu, 09 Sep 2010 13:03:49 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195581#M56021 tresB 2010-09-09T13:03:49Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195582#M56022 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I saw your file, but there isn't clear what are you expecting, I mean, If you want a Top 10 for every column, maybe a Branch could be in a top 10 of the first column but not in the second one.</P><P>If you check out my example file, the Branch CHANDIGARH is top 11-12 for the first column, 8 for the second one and 12 for the third, so what will you show in this case?</P><P>Regards.</P></BODY></HTML> Thu, 09 Sep 2010 13:07:33 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195582#M56022 2010-09-09T13:07:33Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195583#M56023 <HTML><HEAD></HEAD><BODY><P>Hi Gallego,</P><P>I need top 10 record in every coloum like in case of file no if chandigarh is having highest no of cases then that should be on top after that another branch ahemadabad may be at no 2 in file no counting so that should be no 2 in rank ...........</P><P>by this way i need top 10 record in coloums branch in not associated with this top ten because these coloums are having amount and cases nos.......</P></BODY></HTML> Thu, 09 Sep 2010 13:20:54 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195583#M56023 2010-09-09T13:20:54Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195584#M56024 <HTML><HEAD></HEAD><BODY><P>okie now simple one ........</P><P>i need top ten records based on amount............ 2 nd coloumn........</P><P>can you do it for me ...........</P><P></P><P></P><P>Regards,</P><P>Dushyant</P></BODY></HTML> Thu, 09 Sep 2010 13:28:03 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195584#M56024 2010-09-09T13:28:03Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195585#M56025 <HTML><HEAD></HEAD><BODY><P>i need top 10 records based on current month amount .......................</P></BODY></HTML> Thu, 09 Sep 2010 13:35:39 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195585#M56025 2010-09-09T13:35:39Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195586#M56026 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Goto "Sort" tab. Select your "Current month amount" column from priority llist and promote it to the top. Now select SortBy: "Numeric Valu"-&gt; Descending.</P><P>Come to "Presentation" tab. Check "Max Number[1-100]" and put 10 in the value..</P><P>Your work is done..........! Hope this is what you want...</P><P>Regards,</P><P>tresesco</P></BODY></HTML> Thu, 09 Sep 2010 13:52:11 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195586#M56026 tresB 2010-09-09T13:52:11Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195587#M56027 <HTML><HEAD></HEAD><BODY><P>Hi Dushyant,</P><P>In case of Pivot Table you will not find Max Number visible. As it works only for Straight Table. Therefore you need to convert Pivot to Striaght Table to achieve this.</P><P>To achieve your requirement.</P><P>i need top 10 records based on current month amount .......................</P><P>I think that you need to use expression sorting from Sort Tab and put the desired expression like</P><P>Sum( If( Month = $(vCurrentMonth), SalesAmount ) )</P><P>and select "Numeric Value" Descending manner.</P><P>Hope, it would give you desired result.</P><P>Regards,</P><P>Raj Kishor</P><P></P></BODY></HTML> Thu, 09 Sep 2010 14:14:41 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195587#M56027 2010-09-09T14:14:41Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195588#M56028 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Here you are a possible solution. I hope it helps you.</P><P>Regards.</P></BODY></HTML> Thu, 09 Sep 2010 15:23:10 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195588#M56028 2010-09-09T15:23:10Z https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195589#M56029 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Here you are a better and faster solution using a calculating dimension.</P><P>Regards.</P></BODY></HTML> Fri, 10 Sep 2010 10:08:49 GMT https://community.qlik.com/t5/QlikView/Top-function-in-Pivot-Table/m-p/195589#M56029 2010-09-10T10:08:49Z