How to use getfieldSelection in Aggr

[vikasmahajan]

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

[sunny_talwar]

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, '], [') & ']'))

[vikasmahajan]

Hi Sunny

Thanks for reply 

FieldName i have multiple in geographydrill (hierarchical drill)  how to use drill in this formula

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

[sunny_talwar]

This

Sum([CY Sale])/Aggr(NoDistinct Sum({<[Company]=>}[CY Sale]), MonthName, $(='[' & GetFieldSelections(GeographyDrill, '], [') & ']'))

[vikasmahajan]

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