topic Re: Top 5 regions in QlikView https://community.qlik.com/t5/QlikView/Top-5-regions/m-p/455969#M170246 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert i managed to get this one rite....... thanks for replying.....ur answer is correct......</P></BODY></HTML> Thu, 20 Dec 2012 16:36:11 GMT 2012-12-20T16:36:11Z Top 5 regions https://community.qlik.com/t5/QlikView/Top-5-regions/m-p/455967#M170244 <HTML><HEAD></HEAD><BODY><P>I've 3 columns Product, region, sales...For each product there is sales in diffrent regions.&nbsp;&nbsp; I've one 1 region which is Europe let's say..... In my top 5 sales for the region....I always want Europe to be there. So if i&nbsp; make select any product it shud show me Europe + other 4 regions even if Europe is not featuring in top 5.</P></BODY></HTML> Thu, 20 Dec 2012 10:24:11 GMT https://community.qlik.com/t5/QlikView/Top-5-regions/m-p/455967#M170244 2012-12-20T10:24:11Z Re: Top 5 regions https://community.qlik.com/t5/QlikView/Top-5-regions/m-p/455968#M170245 <HTML><HEAD></HEAD><BODY><P>Try as calculated dimesion:</P><P>=If(aggr(Rank(Sum({&lt;Region-={'Europe'}&gt;}Sales)),Product) &lt; 5 or Region= 'Europe' ,Region)</P><P>It gets the top 4 exclusive Europe and then adds Europe to the top 4.</P></BODY></HTML> Thu, 20 Dec 2012 15:15:37 GMT https://community.qlik.com/t5/QlikView/Top-5-regions/m-p/455968#M170245 Gysbert_Wassenaar 2012-12-20T15:15:37Z Re: Top 5 regions https://community.qlik.com/t5/QlikView/Top-5-regions/m-p/455969#M170246 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert i managed to get this one rite....... thanks for replying.....ur answer is correct......</P></BODY></HTML> Thu, 20 Dec 2012 16:36:11 GMT https://community.qlik.com/t5/QlikView/Top-5-regions/m-p/455969#M170246 2012-12-20T16:36:11Z