topic Re: segmentation chart in QlikView

segmentation chart

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

do any one have idea how to create a chart to show segments based on the profit and revenue?

high revenue, less profit

hight reveneu,high profit

less revenue,less profit

less revenue,high profit

above are segments.

i have fields like revenue, and profit.

anyone suggest?

Gautham

Re: segmentation chart

Anil_Babu_Samineni — Tue, 23 Aug 2016 09:45:54 GMT

Can you please provide sample, meantime please explain more

Re: segmentation chart

gauthamchilled — Tue, 23 Aug 2016 12:19:06 GMT

bump

Re: segmentation chart

avinashelite — Tue, 23 Aug 2016 12:43:06 GMT

Is that segments are static ?? if that is the case one easy way would be is to add it as a background image for a chart and use for the analysis

Re: segmentation chart

effinty2112 — Tue, 23 Aug 2016 13:00:56 GMT

Hi Gautham,

I would try a scatter chart with dimension Customer (or whatever is appropriate in your data model) and these expressions. Add a couple of reference lines at x=0.5 and y = 0.5 to divide the chart into the four quadrants you're interested in.

(Sum(revenue) -min(TOTAL Aggr(Sum(revenue),Customer)))

(max(TOTAL Aggr(Sum(revenue),Customer))-min(TOTAL Aggr(Sum(revenue),Customer)))

(Sum(profit) -min(TOTAL Aggr(Sum(profit),Customer)))

(max(TOTAL Aggr(Sum(profit),Customer))-min(TOTAL Aggr(Sum(profit),Customer)))

Cheers

Andrew