How do I exclude certain objects when counting in an expression?

Fri, 16 Apr 2010 11:56:04 GMT

Hello

I am new to QlikView so please be patient with me. I may not use the correct terminology for things. [:)]

I would like to make an expression that counts each object in a field that have a connection to another field.

To clarify I can explain the scenario:
I have a field containing invoices (or rather their IDs). An invoice can have two different types (purchase or sales), but lack a field separating the two. However, I can see wether an invoice is connected to a purchase or a sale by looking at the fields of those objects.

I simply want to count all the invoices that ONLY are connected to sales, and exclude the purchase invoices. For example:

**** count (InvoiceID, if (PurchaseID is unavailable) ****

I appreciate any help I can get, even if it's just a tip on where I can find this kind of information.

//Johannes

How do I exclude certain objects when counting in an expression?

Fri, 16 Apr 2010 12:25:30 GMT

Try this: count(if(len(PurchaseID)=0, InvoiceID))

It is recommended to use len(Field) rather than isnull(field) as the isnull() function is unreliable in some environments (64-bit).

How do I exclude certain objects when counting in an expression?

Fri, 16 Apr 2010 14:57:46 GMT

Thank you very much! Worked like a charm. You just made my day.

topic How do I exclude certain objects when counting in an expression? in QlikView

How do I exclude certain objects when counting in an expression?

How do I exclude certain objects when counting in an expression?

How do I exclude certain objects when counting in an expression?