how to get top 5 repetitive values - Qlik Community

Report Inappropriate Content · ‎2013-09-19

i have a scenario where i have to get top 5 repetitive complaints of the month

how can i achieve this?

er_mohit · ‎2013-09-20

Try this way with your data fields

=If(AGGR (rank(sum(Sales)), Customer) <=5 , Customer)

tresB · ‎2013-09-20

Try:

If(AGGR (Rank(Count(Sales)), Customer) <=5 , Customer)

Report Inappropriate Content · ‎2013-09-20

but how this expression will find the repetitive values?

tresB · ‎2013-09-20

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.

Report Inappropriate Content · ‎2013-09-20

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

tresB · ‎2013-09-20

Hi Shivali,

may be like attached sample?