Top X% of Customers = Y% of Sales

carolin01 — Mon, 17 Mar 2014 16:36:55 GMT

Hello,

I´m trying to design a chart with a slider that is related to a variable. Currently when I use that slider then the chart will show the customers that contribute to Y% of Sales (column Accumulated %). But that´s not what I would like to do. Instead I would like to choose my top X% customers and see to how much of the total Sales they contribute. Therefore the slider and the variable need to be connected to the fomula in the column: Count Of customers in Total in %. With the column Rank I arrange the sort order.

This is my chart to far:

This is the formula for Count of Customers in Total in %:

=(rank($(=vCalcTotalYear1)) ) / (sum(total(aggr(count({$<FYear = {$(vChooseYear1)}, OrderPhase_Desc = {$(vOrderPhaseDesc)}, SoldToBusinessPartnerCount = {1}>} distinct SoldToBusinessPartnerCount), SoldToBusinessPartner))) )

Many thanks for your ideas.

Best regards,

Carolin

topic Top X% of Customers = Y% of Sales in QlikView

Top X% of Customers = Y% of Sales