Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

andyscslots
New Contributor III

ignoring dimension filters based on a specific month

I want a KPI filter to show the average for the 'mfg_DCIPU' for the selected 'MonthYear'  filter of 20174 (which works out at 2200) while ignoring mfg_cat filters or any others .

I used the following expression: Avg({1 <mfg_DCIPU>} mfg_DCIPU) but it only returns the mfg_DCIPU for the entire data range (2100) while ignoring all other filters

All help appreciated

     

mfg_catMonthYearYearMonthMonthNbrmfg_DCIPU
Bally201642016April41000
IGT201642016April42000
Konami201642016April43000
Bally201742017April41100
IGT201742017April42200
Konami201742017April43300
3 Replies

Re: ignoring dimension filters based on a specific month

Remove the 1 and see if that works

Avg({1<MonthYear = p(MonthYear)>} mfg_DCIPU)

or

Avg({1<MonthYear = $::MonthYear>} mfg_DCIPU)

andyscslots
New Contributor III

Re: ignoring dimension filters based on a specific month

thanks again Sunny

Re: ignoring dimension filters based on a specific month

Not a problem. Please close the thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Community Browser