Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Quantile calculation with non numeric first dimension

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!

Example.jpg

2 Replies
JonnyPoole
Former Employee
Former Employee

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 .

Not applicable
Author

Hello Jonathan,

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

Greetings

Alex