Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
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
lironbaram
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
lironbaram
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
MVP

Re: Month Wise Market Share Calculation in QS

Or try this

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

vikasmahajan
Honored Contributor III

Re: Month Wise Market Share Calculation in QS

Thanks Liron  it works for me !!

Vikas

vikasmahajan
Honored Contributor III

Re: Month Wise Market Share Calculation in QS

Thanks Sunny