New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP

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

Hi Sunny

MVP

Re: How to use getfieldSelection in Aggr

This

Sum([CY Sale])/Aggr(NoDistinct Sum({<[Company]=>}[CY Sale]), MonthName, \$(='[' & GetFieldSelections(GeographyDrill, '], [') & ']'))
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