Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ond
Former Employee
Former Employee

Filter Expression

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

 

1 Solution

Accepted Solutions
ond
Former Employee
Former Employee
Author

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

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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
Former Employee
Former Employee
Author

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