4 Replies Latest reply: Jan 26, 2018 8:43 AM by vikas mahajan

# How to use getfieldSelection in Aggr

Hi all,

With reference to discussion based on the link  Market Share Calculation Month Wise Market Share Calculation in QS .

I have multiple dimension in my pivot chart where as  I wanted to calculate market share based on many parameters

Like Company,Region1,RegionName,StateName,Territory  etc

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

So i want to use getfieldselection  dynamically when user will select  Company  then company wise market share will be calculated if user select Region1 then I should get Region1 wise MS.

Thanks

Vikas

• ###### Re: How to use getfieldSelection in Aggr

May be this

Sum([CY Sale])/Sum(TOTAL <\$(='[' & GetFieldSelections(FieldName, '], [') & ']')> {<Company>} [CY Sale])

or this

##### Sum([CY Sale])/Aggr(NoDistinct Sum({<[Company]=>}[CY Sale]), \$(='[' & GetFieldSelections(FieldName, '], [') & ']'))
• ###### Re: How to use getfieldSelection in Aggr

Hi Sunny

##### Sum ([CY Sale])/aggr(nodistinct Sum ({<[Company]=>}[CY Sale]), MonthName , GeographyDrill )
• ###### Re: How to use getfieldSelection in Aggr

This

##### Sum([CY Sale])/Aggr(NoDistinct Sum({<[Company]=>}[CY Sale]), MonthName, \$(='[' & GetFieldSelections(GeographyDrill, '], [') & ']'))
• ###### Re: How to use getfieldSelection in Aggr

Unfortunately this not working

my expression is

num(((Sum(Y2Sale)/aggr(nodistinct Sum ({<COMP=>}Y2Sale),Year,\$(='[' & GetFieldSelections(ReportingHierarchy, '], [') & ']')))),'#,##0.0%')

I am using ReportingHierarchy in drill of qlik sense.

Help appreciated.

Vikas