topic Re: Quantile calculation with non numeric first dimension in QlikView

Quantile calculation with non numeric first dimension

Wed, 20 May 2015 14:15:21 GMT

Hi all,

I am trying to create a bar chart displaying the amounts of businesses in each city sorted by quantiles depending on their revenue (please see graph below).

I am guessing the steps in the formula would be:

Step 1: Rank the 100 companies in my sample by revenue (largest to smallest).

Step 2: Define 4 quantiles (each consisting of 25 companies)

Step 3: Count how often each city is represented in each quantile and end up with a bar chart (such as below)

I assume there has to be a formula doing all that work but unfortunately I have not quite figured it out.

I am very grateful for anyone helping me out!

Thank you!

Re: Quantile calculation with non numeric first dimension

JonnyPoole — Wed, 20 May 2015 20:32:45 GMT

Can you share some data that you you used to post the bar chart above ? if you have the data and desired output that would help me .

Re: Quantile calculation with non numeric first dimension

Tue, 26 May 2015 12:41:04 GMT

Hello Jonathan,

please excuse my late response. We found a way to solve the problem. Thanks for your post.

Greetings

Alex