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

Conditional Total

I have below table showing Invoice data against Customer ID.

Customer IDInvoice NoInvoice ValuePAID?
ABC11125NO
PQR12130NO
DEF13140YES
GHI14155YES
JKL15146YES
ABC16128YES
XYZ1799NO
MNO18100NO
PQR19135NO
XYZ20198NO
PQR21197YES
ABC22210YES
DEF23150NO
GHI2495NO
JKL2550NO

I want to get total value of unpaid invoices against each Customer ID.

Can someone please give me script?

The result should be as below

Customer IDInvoice Value Not Paid
ABC125
DEF150
GHI95
JKL50
MNO100
PQR265
XYZ297
TOTAL1082


Thaks in advance.

1 Solution

Accepted Solutions
MVP
MVP

Conditional Total

Hi,

use customer ID as dimension and as expression

=sum({<[PAID?]={'NO'}>} [Invoice Value])

assuming that Invoice Value, PAID? are your field names.

Stefan

2 Replies
MVP
MVP

Conditional Total

Hi,

use customer ID as dimension and as expression

=sum({<[PAID?]={'NO'}>} [Invoice Value])

assuming that Invoice Value, PAID? are your field names.

Stefan

Not applicable

Conditional Total

Thanks for your quick response. It's Working fine.

Community Browser