- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Tags:
- qlikview_scripting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think it should be solved somehow by a rank function, but I don't know how to do the middle quartiles
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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