Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
May be this
Sum([CY Sale])/Sum(TOTAL <$(='[' & GetFieldSelections(FieldName, '], [') & ']')> {<Company>} [CY Sale])
or this
Hi Sunny
Thanks for reply
This
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