ignoring dimension filters based on a specific month

[Anonymous]

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_cat	MonthYear	Year	Month	MonthNbr	mfg_DCIPU
Bally	20164	2016	April	4	1000
IGT	20164	2016	April	4	2000
Konami	20164	2016	April	4	3000
Bally	20174	2017	April	4	1100
IGT	20174	2017	April	4	2200
Konami	20174	2017	April	4	3300

[sunny_talwar]

Remove the 1 and see if that works

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

or

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

[Anonymous]

thanks again Sunny

[sunny_talwar]

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny