Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-03-12 08:18 AM

Market Share Calculation

Hello Everyone,

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

Thanks & Regards,

Prachi Dhok.

866 Views
0 Likes
4 Replies
isingh30
Specialist
Specialist
‎2018-03-12 10:44 AM

Can you share your data or app?

732 Views
0 Likes
shiveshsingh
Master
Master
‎2018-03-12 11:06 AM

aggr(sum(Sales),Market)


May be this, please share sample app/data

732 Views
0 Likes
ajaysingh285
Contributor III
Contributor III
‎2018-03-12 11:19 AM

Hi Prachi,

Its simply Sum(Sales).

Thanks,

Ajay

732 Views
0 Likes
PrashantSangle
MVP
MVP
‎2018-03-12 12:28 PM

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
732 Views
0 Likes