Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
antonybi
Contributor

Help needed

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!

Tags (1)
2 Replies

Re: Help needed

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
antonybi
Contributor

Re: Help needed

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 ?