topic Re: Script for market share in QlikView

Script for market share

Thu, 11 Sep 2014 13:26:02 GMT

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

Re: Script for market share

MarcoWedel — Sat, 13 Sep 2014 11:15:09 GMT

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

Re: Script for market share

IAMDV — Sat, 13 Sep 2014 11:38:49 GMT

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,

www.QlikShare.com

Re: Script for market share

MarcoWedel — Sat, 13 Sep 2014 11:42:05 GMT

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

Re: Script for market share

Sun, 14 Sep 2014 23:30:47 GMT

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

Re: Script for market share

MarcoWedel — Mon, 15 Sep 2014 05:54:49 GMT

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