topic Re: Filter Expression in QlikView

Filter Expression

ond — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to QlikView and need your help. I am trying to built an app for commissions and payments for the Sales.

I have a straight table where I show how much every rep earned YTD and how much he was paid YTD. Both fields are calculated expressions. And I also have a resulting balance which is the difference between the 2. The balance is what needs to be paid next month.

As a balance can be positive, negative or 0, I want to be able to filter on those categories either through a button or a flag or list box or something.

I've attached an example image.

How can I build this?

Many thanks for your help!

Andreea

Re: Filter Expression

marcus_sommer — Tue, 18 Feb 2020 13:39:51 GMT

As expression within a listbox you could try something like this:

Year & ' - ' & pick(sign(aggr(sum(Earned) - sum(Paid), Person, Year)) + 2, 'negative', 'no pay', 'positive')

- Marcus

Re: Filter Expression

ond — Fri, 13 Mar 2020 10:11:17 GMT

Thank you, Marcus. I actually found another way to do it but will use your solution for another case app.