Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Valued Contributor II

Re: Calculate market share


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

Valued Contributor

Re: Calculate market share

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



Community Browser