topic Help needed in QlikView

Help needed

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Help needed

Anil_Babu_Samineni — Thu, 05 Jul 2018 14:15:31 GMT

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%','#.#'))))

Re: Help needed

antonybi — Thu, 05 Jul 2018 14:27:24 GMT

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 ?