Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Script for market share

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

5 Replies
MarcoWedel
Not applicable

Re: Script for market share

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
Not applicable

Re: Script for market share

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
Not applicable

Re: Script for market share

Not applicable

Re: Script for market share

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
Not applicable

Re: Script for market share

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