Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Filtering Help Needed

Here is what I am trying to do....I have two dimension columns one with unique order numbers another with the payment amount.

If you look at the example below orders 001 and 004 have two entries as Payments were made then refunded.

Basically I want the orders  not be shown whereby the total in the payment column equals $0

So in the below example only order 002 and 003 should be shown in the report.

Any help would be great!

Order NumberPayment
001$100
001($100)
002$345
003$490
004$250
004($250)
2 Replies

Re: Filtering Help Needed

Hi

     Try like this

     Use Order Number as dimension

     Exp: =if(Sum(Payment) > 0, sum(Payment))

     Hope it helps

whiteline
Honored Contributor II

Re: Filtering Help Needed

Hi.

Instead of Order Number you can use calculated dimension:

=aggr(Only({<[Order Number]={"=(Sum(Payment)<>0)"}>} [Order Number]), [Order Number])

also toggle checkbox 'supress when value is null'.

And Instead of using Payment as dimension transform it to expression Sum(Payment).

Community Browser