topic Re: Expression filter in QlikView

Expression filter

Sat, 25 Apr 2015 11:23:00 GMT

Hi,

I have one straight table chart with PO Number, Order Amt,, Open Invoice Amt, Paid Invoice Amt and an expression called Discrepancy Amt with formula (Open Invoice Amt - Closed Invoice Amt). I have second straight table chart with Invoice and Open Invoice Amt and Paid Invoice Amt. I want to achieve 2 things.

1) I want to select the PO Number with my expression being Positive or Negative by click of a button

2) As I filter on the PO Number from my first chart its associated invoice should automatically get filtered on the second chart.

Thanks

Re: Expression filter

MK_QSL — Sat, 25 Apr 2015 12:17:23 GMT

Provide few lines of sample or dummy data... I have created similar application in past...

Re: Expression filter

swuehl — Sat, 25 Apr 2015 12:19:14 GMT

You can try something like this:

Create a button chart object with action Selection - Select in field titled 'Selection of positive Discrepancy Amt'

field name is PO Number

search string is

=([Open Invoice Amt] - [Closed Invoice Amt]) > 0

Similar for a button with negative Amts. This will select the PO Numbers according to the Disc. Amt, and the selections should automatically be reflected in your second chart, too.

Re: Expression filter

Sat, 25 Apr 2015 13:28:53 GMT

Sample file attached

Re: Expression filter

Sat, 25 Apr 2015 15:02:29 GMT

Hi,

Your idea worked with small glitch. When I have 2 buttons only the second click of the button gives me expected results.

Thanks

Venkatachalam.N

Re: Expression filter

swuehl — Sun, 26 Apr 2015 12:09:41 GMT

You can try adding another action to each button, place the new action before the Selection action you've created.

Create an action to clear all selections or clear selection in field PO Number.

Re: Expression filter

Sun, 26 Apr 2015 16:32:21 GMT

Thanks and it works now.