Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mrainey18
Contributor

Set Analysis Exclude one field but Include another

I am trying to find the average sales for one employee for each category and compare that employee to the average sales of all other employees.  BUT I only want the categories associated with the selected employee.  I dont want to have to select all the categories.

This gets me the first half:

Avg(Sales)  // For one employee

Avg({<FullName=,EmployeeID=>}Sales) // For all employees

I just now need to only display the selected employees Categories.

1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis Exclude one field but Include another

Maybe this if Category is your dimension field and you've selected an employee:

Avg({<FullName=,EmployeeID=, Category = p() >}Sales)

2 Replies
MVP
MVP

Re: Set Analysis Exclude one field but Include another

Maybe this if Category is your dimension field and you've selected an employee:

Avg({<FullName=,EmployeeID=, Category = p() >}Sales)

mrainey18
Contributor

Re: Set Analysis Exclude one field but Include another

P() &amp; E() and where do you use them?

I'm referencing this because I've never heard of these before.  Thank you for your quick answer!