topic Re: Cannot filter in app after filtering in expression? in QlikView

Cannot filter in app after filtering in expression?

jisephcirspy — Sat, 16 Nov 2024 17:46:23 GMT

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?

Re: Cannot filter in app after filtering in expression?

Chanty4u — Thu, 26 Nov 2020 14:10:32 GMT

tried this?

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

Re: Cannot filter in app after filtering in expression?

jisephcirspy — Thu, 26 Nov 2020 14:19:28 GMT

I LOVE YOU ❤️ @Chanty4u
you saved my day

Re: Cannot filter in app after filtering in expression?

Chanty4u — Thu, 26 Nov 2020 14:22:19 GMT

Great it worked for you !!

Have a nice day.

Best

Chanty4u