Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jisephcirspy
Contributor III
Contributor III

Cannot filter in app after filtering in expression?

So, I want to get the average salary without the salary of the manager. My expression looks like this:

avg({<job=-{'manager'}>} salary)

But when I use this expression I cannot filter further in the app itself. Like for example, I want to get the average salaray of the male workers. It doesn't work.

When I do it like this, I can filter:

avg(salary)

But then, the default isn't without the manager's salary.

Can you help me?

Labels (3)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Hi

tried this?

avg({<job*=-{'manager'}>} salary)

or

avg({<job*={'manager'}>} salary)

View solution in original post

3 Replies
Chanty4u
MVP
MVP

Hi

tried this?

avg({<job*=-{'manager'}>} salary)

or

avg({<job*={'manager'}>} salary)
jisephcirspy
Contributor III
Contributor III
Author

I LOVE YOU ❤️ @Chanty4u 
you saved my day

Chanty4u
MVP
MVP

Great it worked for you !! 

Have a nice day.

 

Best

Chanty4u