Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yogendrawasaika
New Contributor

Calculate market share

Can some please help  me on how to calculate market share for sales of different products for different region. Below is the example table. In the attached table i want to calculate market share for product A for X region, Y region, etc. Similarly for B product, C product.


Product, Region, Sales

A, X, 50

A, Y, 520

B, X, 500

B, Y, 10

C, X, 800

C, Y, 400

C, Z, 200


Thanks in advance.

Tags (1)
2 Replies
vvira1316
Valued Contributor II

Re: Calculate market share

Share.PNG

Sum(Sales)/Sum({<Region>} TOTAL <Product> Sales)

zebhashmi
Valued Contributor

Re: Calculate market share

Sum(Sales)/Sum(TOTAL <Product> Sales)

or

=Sales/Sum(total<Region>Sales)

Community Browser