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!