topic Re: Market Share Calculation in QlikView

Market Share Calculation

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

Hello Everyone,

I come to know how to calculate Market share from given Value(Sales).

Thanks & Regards,

Prachi Dhok.

isingh30 — Mon, 12 Mar 2018 14:44:06 GMT

Can you share your data or app?

shiveshsingh — Mon, 12 Mar 2018 15:06:15 GMT

aggr(sum(Sales),Market)

May be this, please share sample app/data

ajaysingh285 — Mon, 12 Mar 2018 15:19:47 GMT

Hi Prachi,

Its simply Sum(Sales).

Thanks,

Ajay

PrashantSangle — Mon, 12 Mar 2018 16:28:02 GMT

Market share is nothing but your sales for current region w.r.t. Total Sales.

If you google it you will find basic formula for it

Formula

Expression : sum(Sales)/Sum(TOTAL Sales)

Dimension : Region

Regards,