Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhanshu123
Partner
Partner

need help in getting sum(sales) of top 5 and top 10 customers Monthwise on bar chart

Hi ALL

need help in getting sum(sales) of top 3 and top 2 customers Monthwise on bar chart.

Have data like

Sales Customers     Month

10      Rag Limitd      Jan

30     Rag Limited    Feb

47     Part Finance   March

68     Pany Auto     April

78     Part Finace    May

30     Rag Limited    Feb

47     Part Finance   March

68     Pany Auto     April

78     Part Finace    May

68     Pany Auto     April

78     Part Finace    May

30     Rag Limited    Feb

Please Help

Thanks Sudhanshu shrivas

3 Replies
Chanty4u
MVP
MVP

try this exp

Dim:Month

Exp: =aggr(if(rank(sum([Sales]))<=3,customers),Customers)

lakkydev
Creator II
Creator II

Please check below app for you Question

benjamins
Partner
Partner

I'd say your sample data is insufficient, as each Month only has one customer.

That being said, you need to assign a rank to each of the Customers per Month, as in attached sample (all done in skript).

You can then proceed to only Display the desired customers.