Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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
Master II
Master II

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

Not applicable
Author

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