Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nmarinelli
Partner
Partner

How to Build a Lorenz Curve in Qlik Sense?

Hi,

I am trying to build something similar to a Lorenz Curve (https://en.wikipedia.org/wiki/Lorenz_curve) in QlikSense like the chart below. 

Lorenz Curve.PNG

I currently have a list of Customers and yearly sales (aggregated per customer) like the following:

CustomerSales
A1743
B532
C1323

 

I would like to display the Customer percentile on the x-axis and their corresponding sales percentile on the y-axis. I'm able to create the above curve by pre-sorting the customers by sales and pre-calculating each customer's percentile rank and the cumulative sales up to each customer in the load script-- however the chart is then obviously not responsive to filters in Qlik. Has anyone had luck creating a Lorenz Curve on the front end that will respond fully to selections?

0 Replies