Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Share (%) of parent total

Hello everyone!

I'm new to Qlik Sense, and I faced a simple case which I can't resolve myself of using help or forum.

I have normalized table showing [Sales] of each [Brand] over the time [Year_Quarter]. [Brands] are gripped into markets by additional column [Market]:

Data_source.jpg

The all I need is to create a Measure [Market Share] to show % share of each brand on its parent market total (see the yellow cells at the screenshot bellow).

Desired _Result.jpg

I can easy create it in Excel or Power Query, but I unable to make it right in Qlik Sense.

The statements I'he already tried:

  1. sum(Sales)/Sum({$<Brand=>} Sales)
  2. sum(Sales)/sum({TOTAL<Brand> * $<Market>} Sales)
  3. sum(Sales)/sum({$<[Brand]= {*}>} Sales)
  4. some more variants that I have not marked...

Can anybody help me with this?

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum(Sales)/Sum(TOTAL <Market, YearQuarter> Sales)

View solution in original post

2 Replies
sunny_talwar

May be this

Sum(Sales)/Sum(TOTAL <Market, YearQuarter> Sales)

Anonymous
Not applicable
Author

Thank you!

Very simple and powerful.

Logic is clear..