topic Re: ignoring dimension filters based on a specific month in App Development

ignoring dimension filters based on a specific month

Anonymous — Sat, 16 Nov 2024 08:52:10 GMT

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

Re: ignoring dimension filters based on a specific month

sunny_talwar — Thu, 18 Jan 2018 17:37:51 GMT

Remove the 1 and see if that works

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

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

Re: ignoring dimension filters based on a specific month

Anonymous — Fri, 19 Jan 2018 03:21:35 GMT

thanks again Sunny

Re: ignoring dimension filters based on a specific month

sunny_talwar — Fri, 19 Jan 2018 09:14:35 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny