topic conditional Expression in QlikView

conditional Expression

Mon, 21 Nov 2011 10:03:16 GMT

Attached is one of my simple expression which sums a column. Now I want to add a condition in the expression where it should sum the 'Invoiceamount' only when there is no word like 'Rejected' in the Status column.

With reference to the attached image, the red one should not be a part of sum

Re: conditional Expression

Mon, 21 Nov 2011 10:25:11 GMT

Sum({$<Status={'Pending'}>}InvoiceAmount).

Best Regards,
Vishal

conditional Expression

Mon, 21 Nov 2011 10:34:24 GMT

Thanks for the expression. But here I need a statement where it looks for a word 'Rejected' in a statement.

In SQL you will represent it as (Status like 'Rejected%)

conditional Expression

Mon, 21 Nov 2011 11:00:51 GMT

Try this in your expression:

sum({<Status-={'*Rejected*'}>}InvoiceAmnt)

Cheers,

Shyam

Re: conditional Expression

Mon, 21 Nov 2011 12:00:51 GMT

Thanks it works,

How can I filter the Rejected and Cancelled in Status field from the report as per the attached image.