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: 
vikasmahajan

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

you can use this expression

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

View solution in original post

4 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

you can use this expression

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

sunny_talwar

Or try this

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

vikasmahajan
Author

Thanks Liron  it works for me !!

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan
Author

Thanks Sunny

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.