Need help with filter set analysis in new qlik dashboard.

[dhern2012]

Hi. 

I am trying to create a dashboard with a few metrics on it. I provided a sample data sheet in an excel file. 

Essentially, I am trying to show the following metrics. 

average Sales by Employee_id / Month

average sales by employees overall across the month

average sales by employees overall in the city that matches city that selected employee in filter is in.

I am having the most trouble with the last one. I have been able to do set analysis to give me overall. 

On the top I have the following filters: Employee_ID, month, city

I just need help figuring out how to make the last metric to be dynamic enough to change the city that selected employee is in. I wasn't able to provide actual data, but created a sample sheet. 

[rbartley · Accepted solution]

Hi,

Try using the P() modifier, e.g.

Avg({$<CITY=P(CITY),EMPLOYEE_ID=>}SALES_VOLUME)

The above gets a set of all possible cities based on the selections, but excludes the employee selection from the average calculation.  

[sidhiq91 · Accepted solution]

@dhern2012  Please use the below expression:

Avg({<CITY=P(CITY),EMPLOYEE_ID=,MONTH=>}SALES_VOLUME)

If this resolves your issue, please like and accept it as solution.