Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
andyscslots
Contributor III
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
Labels (1)
3 Replies
sunny_talwar

Remove the 1 and see if that works

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

or

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

andyscslots
Contributor III
Contributor III
Author

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