Announcements
cancel
Showing results for
Did you mean:
Contributor II

## Ranking with quartiles

Hello,

I am quite new to Qlik. I Need to create a Ranking table of Customers according to Salesamount.

Customers should be ranked into first 10 and Bottom 10 percent. The left customers should be devided into 1. and 2. Quartil.

The table should look like this in the end:

Rank           RankMapping CustomerID

1                     First 10%         129875

2                     First 10%          023948

10                  1. Quartil          023455

80                  2.Quartil          029354

100               Bottom 10%   485895

Thank you!

Labels (1)
• ### ranking qlikview

5 Replies
Master II

May be  you need the below

Have a look at the article and it's related articles. Hopefully it helps.

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

Learning never stops.
Contributor II
Author

I think it should be solved somehow by a rank function, but I don't know how to do the middle quartiles

Contributor II
Author

SOMETHING SIMILAR TO THIS BUT WITH top top 10% ,1.quartil 2.quartil, Bottom 10%

=Avg( TOTAL<quarter> Aggr( If( Rank( Sum(result),4,0) <= Count(TOTAL<quarter>result) / 10, Sum(result) ), quarter, key))

Contributor II
Author

To make it clearer it should look like this in the end

Rank           RankMapping CustomerID

1                     First 10%         129875

2                     First 10%          023948

3

4

...

10                  1. Quartil          023455

11               1. Quartil          023655

...

80                  2.Quartil          029354

81                   2.Quartil          029356

...

100               Bottom 10%   485895

101              Bottom 10%   485795

Contributor II
Author

so it is something like

if  rank <10% then "First10%"

else if rank>10% and <50% then "1.Quartil"

else if rank>50% and <90% then "2.Quartil"

else Bottom 10%

But I dont know the exact Expression in QlikView.

Anyone knows how it works?

Thank you

Community Browser