Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
Honored Contributor III

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

4 Replies

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, '], [') & ']'))
vikasmahajan
Honored Contributor III

Re: How to use getfieldSelection in Aggr

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 )

Re: How to use getfieldSelection in Aggr

This

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

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

Community Browser