Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oseimuduame
Creator II
Creator II

TOP Shoppers Report

Good Morning guys,

I am trying to get a report for Top 100 shoppers and i used Dimension Limits but its not showing the accurate result.

Is there a formula i can use for top shopper apart from Dimension limits

Await Ideas Please

2 Replies
Anonymous
Not applicable

You can try to achieve it by using rank() function in calculated dimension

=Aggr(

    If(Rank(

        Aggr(

            <yor expression here>

        , [Your Field])

    , 1, 0) <= 100,

    [Your Field] )

, [Your Field] )

balabhaskarqlik

Try like this:

=if(aggr(Rank(Sum(Sales)),Product) <=100, Product,Null())

or

=aggr(if(rank((sales))<=100,Product,'Others'),name)

or

=Sum({<Customer = {'=Rank(Sum(Sales))<=100'}>} Sales)