topic Re: TOP 3 SALES in QlikView https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846850#M297289 <HTML><HEAD></HEAD><BODY><P>try this,</P><P>1. city as ur dimension</P><P>2. sum(sales) as ur expression</P><P>3. <IMG alt="top 3.PNG" class="jive-image image-1" src="/legacyfs/online/85315_top 3.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 29 Apr 2015 08:14:49 GMT buzzy996 2015-04-29T08:14:49Z TOP 3 SALES https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846848#M297287 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have sales, city columns</P><P>i want top 3 sales of city</P><P>HOw to do it?</P></BODY></HTML> Wed, 29 Apr 2015 08:01:31 GMT https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846848#M297287 2015-04-29T08:01:31Z Re: TOP 3 SALES https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846849#M297288 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>You Can limit Values In the chart Properties in Charts</P></BODY></HTML> Wed, 29 Apr 2015 08:06:15 GMT https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846849#M297288 rajkumarb 2015-04-29T08:06:15Z Re: TOP 3 SALES https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846850#M297289 <HTML><HEAD></HEAD><BODY><P>try this,</P><P>1. city as ur dimension</P><P>2. sum(sales) as ur expression</P><P>3. <IMG alt="top 3.PNG" class="jive-image image-1" src="/legacyfs/online/85315_top 3.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 29 Apr 2015 08:14:49 GMT https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846850#M297289 buzzy996 2015-04-29T08:14:49Z Re: TOP 3 SALES https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846851#M297290 <HTML><HEAD></HEAD><BODY><P>Search the forum. You will get lot of examples</P></BODY></HTML> Wed, 29 Apr 2015 08:34:15 GMT https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846851#M297290 anbu1984 2015-04-29T08:34:15Z Re: TOP 3 SALES https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846852#M297291 <HTML><HEAD></HEAD><BODY><P>Try this in dimension:</P><P>if(aggr(Rank(sum(Sales)),City)&lt;=3,City)</P><P></P><P>In Expression:</P><P>sum(Sales)</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Wed, 29 Apr 2015 08:38:19 GMT https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846852#M297291 jyothish8807 2015-04-29T08:38:19Z Re: TOP 3 SALES https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846853#M297292 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>u can try using dimension limit and also the rank function as well.</P><P></P><P></P><P>Regards</P><P>Deepak</P></BODY></HTML> Wed, 29 Apr 2015 08:45:43 GMT https://community.qlik.com/t5/QlikView/TOP-3-SALES/m-p/846853#M297292 2015-04-29T08:45:43Z