Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Remove the 1 and see if that works
Avg({1<MonthYear = p(MonthYear)>} mfg_DCIPU)
or
Avg({1<MonthYear = $::MonthYear>} mfg_DCIPU)
thanks again Sunny
Not a problem. Please close the thread by marking the correct response.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny