Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have issue with ignore specefic field(~KPIName) selections.
Please help me out in this.
What I have done is so far.....,
I have 2 fields in my dashboard called
KPI Name- existing filed
[~KPIName]-I have created hide field(contains same data of KPI Name)
I have craeted [~KPIName] in the script like below
Set HidePrefix= "~";
Now I have Loaded the table and it contains KPI Name and [~KPIName].
Now I have taken these two list boxes.
In my dashboard dimensions are following
dim1- KPI Name
dim2- Brand
and my expression is some thing like as below
IF(RollingMonth <= MaxCountryDate and RollingMonth >= MinCountryDate,
Pick(Match([KPI Type],'MF','MS'),
Num(Sum({<[Res Dim Key%]=e({$<[Brand Net Multiplier]={'-1'}>}),Year=,Month=,Yardstick={'R3M'},Brand=,[~KPIName]=,
ComparisonType={"None"} ,[Top Box Ind]={'Y'}>} [Res Weight])
/
Sum( {<[Measure ID]={16},Yardstick={'R3M'},[KPI Name]=,Brand=,[~KPIName]=,>} Total<Brand> [Res Weight]),'#,#0.0%')
,
Num((Sum({<[Res Dim Key%]=e({$<[Brand Net Multiplier]={'-1'}>}),Year=,Month=,Yardstick={'R3M'},Brand=,[~KPIName]=
,ComparisonType={"None"}>}
[Res Weight]*[MF Metrix Scale Value])
/
Sum( {<Yardstick={'R3M'},[~KPIName]=>}[Res Weight]))/IF([KPI Name]='Ptential',100,1)
,IF(Match([KPI Name],'Pwer','Ptential'),'##0.0%','#.#'))
)
)
Here I have taken [~KPIName] in the set expression to ignore the selections.
But it is not working as i expected.What I did wrong in the above expression.?
Any suggestions will be appreciated.
Thank U!
Perhaps this?
IF(RollingMonth <= MaxCountryDate and RollingMonth >= MinCountryDate,
Pick(Match([KPI Type],'MF','MS'),
Num(Sum({<[Res Dim Key%]=e({$<[Brand Net Multiplier]={'-1'},[~KPIName]=>} [Res Dim Key%]),Year=,Month=,Yardstick={'R3M'},Brand=,[~KPIName]=,
ComparisonType={"None"} ,[Top Box Ind]={'Y'}>} [Res Weight])
/
Sum( {<[Measure ID]={16},Yardstick={'R3M'},[KPI Name]=,Brand=,[~KPIName]=,>} Total<Brand> [Res Weight]),'#,#0.0%')
,
Num((Sum({<[Res Dim Key%]=e({$<[Brand Net Multiplier]={'-1'},[~KPIName]=>} [Res Dim Key%]),Year=,Month=,Yardstick={'R3M'},Brand=,[~KPIName]=
,ComparisonType={"None"}>}
[Res Weight]*[MF Metrix Scale Value])
/
Sum( {<Yardstick={'R3M'},[~KPIName]=>}[Res Weight]))/IF([KPI Name]='Ptential',100,1)
,IF(Match([KPI Name],'Pwer','Ptential'),'##0.0%','#.#'))))
Thanks for your quick response.
Before I have no issues with the existing expression.
Only Problem with [~KPIName] after added into the existing expression, it is not giving what exactly am looking for...
However, my ultimate goal is the dash board should reflect based on the selections with KPI Name
but not [~KPIName]
Can we have any other ways to achieve this ?