Script for market share

[#1]

what is the script for market share when you have the raw values in your data

[MarcoWedel]

Hi,

one possible solution could be:

LOAD
   ...,
    SomeFunction(RawValue) as MarketShare,
   ...,
FROM YourData
...
;

To specify the solution, maybe you could provide some more details, e.g. what your raw data and the expected result of the script, you're asking for, might look like.

hope this helps

regards

Marco

[IAMDV]

Nicholas,

Are you referring Market Share formula?

Market Share = (Particular Company's Sales Revenue in Time Period X) / (Relevant Market's Total Sales Revenue in Time Period X)

If not, please explain in detail.

Cheers,

DV

www.QlikShare.com

[MarcoWedel]

maybe also helpful:

QlikCommunity Tip: How to get answers to your post?

Its not about the answer, rather it’s about the question…

regards

Marco

[#5]

Hi,

I have Field Headings:

MMM-YY

Brand

Unit Sales

I am wanting to know the script to calculate Monthly Market Share, that is, for any given month:

Brand A Unit Sales / Brand A Unit Sales + Brand B Unit Sales + Brand C Unit Sales

I hope that is clearer.

Or is there a function within Qlik Sense, that does this automatically.

Thanks.

Nick

[MarcoWedel]

Just create a chart with Dimension Brand and expression sum(sales), mark relative for this expression. When selecting one month, you will get the share for each Brand per this month. Otherwise add month as Dimension to get the share values for all months.

Regards

Marco