topic Dinamic table - Top 10 in QlikView https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/222999#M75568 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>Is it possible create a dinamic showing in my dimensions just the top 15 Clients ?</P></BODY></HTML> Wed, 29 Sep 2010 21:19:32 GMT 2010-09-29T21:19:32Z Dinamic table - Top 10 https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/222999#M75568 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>Is it possible create a dinamic showing in my dimensions just the top 15 Clients ?</P></BODY></HTML> Wed, 29 Sep 2010 21:19:32 GMT https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/222999#M75568 2010-09-29T21:19:32Z Dinamic table - Top 10 https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223000#M75569 <HTML><HEAD></HEAD><BODY><P>In the Sort tab you can sort in descending order your customers using an expression like sum(Sales) and then in the Presentation tab enable the option to show a maximum of 10 or 15.</P><P>Or what part do you want to be dynamic?</P></BODY></HTML> Wed, 29 Sep 2010 21:33:52 GMT https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223000#M75569 pover 2010-09-29T21:33:52Z Dinamic table - Top 10 https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223001#M75570 <HTML><HEAD></HEAD><BODY><P>You could also use the rank function in a table object...</P><P>rank(sum(sales),0,1)) will produce a statistic with ranking of the clients by "sales". That way you would have a list of clients and you can have their ranking right beside them. check out the rank function. There are different "modes" you can use. the modes i have used above will show ties as the same rank. So if there were two clients that had the same sales (given your current filters) they would both be reprsented as a ranking of "2".</P><P></P><P></P></BODY></HTML> Wed, 29 Sep 2010 22:51:03 GMT https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223001#M75570 Anonymous 2010-09-29T22:51:03Z Dinamic table - Top 10 https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223002#M75571 <HTML><HEAD></HEAD><BODY><P>Tks for answer Karl, but I dont have in my dinamic table properts in a presentation tab the option to show a maximum of 10 or 15...</P></BODY></HTML> Thu, 30 Sep 2010 12:52:28 GMT https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223002#M75571 2010-09-30T12:52:28Z Dinamic table - Top 10 https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223003#M75572 <HTML><HEAD></HEAD><BODY><P>I changed the type graphics for simple table and now its ok!</P><P></P><P>Tks a lot!</P></BODY></HTML> Thu, 30 Sep 2010 13:16:47 GMT https://community.qlik.com/t5/QlikView/Dinamic-table-Top-10/m-p/223003#M75572 2010-09-30T13:16:47Z