Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dhern2012
Contributor
Contributor

Need help with filter set analysis in new qlik dashboard.

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. 

Labels (5)
2 Solutions

Accepted Solutions
rbartley
Specialist II
Specialist II

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.  

 

View solution in original post

sidhiq91
Specialist II
Specialist II

@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.

View solution in original post

2 Replies
rbartley
Specialist II
Specialist II

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
Specialist II
Specialist II

@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.