Discussion board where members can get started with Qlik Sense.
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]:
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).
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:
Can anybody help me with this?
Go to Solution.
May be this
Sum(Sales)/Sum(TOTAL <Market, YearQuarter> Sales)
Very simple and powerful.
Logic is clear..