App Development

Discuss and learn more about Qlik Sense app development and usage.

Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

Who Me Too'd this topic

nmarinelli
Partner - Contributor
Partner - Contributor

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?

Who Me Too'd this topic