# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Honored Contributor III

## Month Wise Market Share Calculation in QS

Hi all,

I have following table I wanted to calculate a month wise market share  for each company wise.  it should be 100 % and should not change to 100 % when I select the company

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Month Wise Market Share Calculation in QS

hi

you can use this expression

Sum ([CY Sale])/aggr(nodistinct Sum ({<[Company]=>}[CY Sale]),MonthName)

4 Replies
Honored Contributor II

## Re: Month Wise Market Share Calculation in QS

hi

you can use this expression

Sum ([CY Sale])/aggr(nodistinct Sum ({<[Company]=>}[CY Sale]),MonthName)

MVP

## Re: Month Wise Market Share Calculation in QS

Or try this

Sum([CY Sale])/Sum(TOTAL <MonthName> {<Company>} [CY Sale])

Honored Contributor III

## Re: Month Wise Market Share Calculation in QS

Thanks Liron  it works for me !!

Vikas

Honored Contributor III

Thanks Sunny