Filter Expression

[ond]

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

[marcus_sommer]

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

[ond · Accepted solution]

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