topic how to get top 5 repetitive values in QlikView https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546254#M204049 <HTML><HEAD></HEAD><BODY><P><BR />i have a scenario where i have to get top 5 repetitive complaints of the month</P><P>how can i achieve this?</P></BODY></HTML> Fri, 20 Sep 2013 03:39:42 GMT 2013-09-20T03:39:42Z how to get top 5 repetitive values https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546254#M204049 <HTML><HEAD></HEAD><BODY><P><BR />i have a scenario where i have to get top 5 repetitive complaints of the month</P><P>how can i achieve this?</P></BODY></HTML> Fri, 20 Sep 2013 03:39:42 GMT https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546254#M204049 2013-09-20T03:39:42Z Re: how to get top 5 repetitive values https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546255#M204050 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: #ffffff; font-size: 12pt; font-family: 'Times New Roman', serif; color: blue;">Try this way with your data fields <BR /></SPAN></P><P><SPAN style="background-color: #ffffff; font-size: 12pt; font-family: 'Times New Roman', serif; color: blue;">=If(AGGR (</SPAN><SPAN style="background-color: #ffffff; font-size: 12pt; font-family: 'Times New Roman', serif; color: blue;">rank</SPAN><SPAN style="background-color: white; font-size: 12pt; font-family: 'Times New Roman', serif; color: maroon;">(sum(Sales)), Customer) &lt;=5 , Customer)</SPAN></P></BODY></HTML> Fri, 20 Sep 2013 04:31:13 GMT https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546255#M204050 er_mohit 2013-09-20T04:31:13Z Re: how to get top 5 repetitive values https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546256#M204051 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>If(AGGR (Rank(Count<SPAN style="color: maroon; font-family: 'Times New Roman', serif; font-size: 12pt; background-color: white;">(Sales)), Customer) &lt;=5 , Customer)</SPAN></P></BODY></HTML> Fri, 20 Sep 2013 04:46:41 GMT https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546256#M204051 tresB 2013-09-20T04:46:41Z Re: how to get top 5 repetitive values https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546257#M204052 <HTML><HEAD></HEAD><BODY><P>but how this expression will find the repetitive values?</P></BODY></HTML> Fri, 20 Sep 2013 06:08:14 GMT https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546257#M204052 2013-09-20T06:08:14Z Re: how to get top 5 repetitive values https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546258#M204053 <HTML><HEAD></HEAD><BODY><P>Count() will count the frequency, if you rank on them that means most numbers of times occured sales would be taken into consideration. If any doubt, please sample app.</P></BODY></HTML> Fri, 20 Sep 2013 06:33:14 GMT https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546258#M204053 tresB 2013-09-20T06:33:14Z Re: how to get top 5 repetitive values https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546259#M204054 <HTML><HEAD></HEAD><BODY><P>i have two columns named:complain and month ,i want to get the repetitive compalints of the individual months from jan to dec so how an i achieve this</P></BODY></HTML> Fri, 20 Sep 2013 06:43:12 GMT https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546259#M204054 2013-09-20T06:43:12Z Re: Re: how to get top 5 repetitive values https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546260#M204055 <HTML><HEAD></HEAD><BODY><P>Hi Shivali,</P><P></P><P>may be like attached sample?</P></BODY></HTML> Fri, 20 Sep 2013 08:21:51 GMT https://community.qlik.com/t5/QlikView/how-to-get-top-5-repetitive-values/m-p/546260#M204055 tresB 2013-09-20T08:21:51Z