topic filter in Diagram in QlikView

filter in Diagram

Tue, 12 May 2009 20:47:37 GMT

Hello

I want to filter 5 customer exclude from our Customer (20.000) and use this for a Diagramm. How can i do this.

Thanks

filter in Diagram

Tue, 12 May 2009 21:00:23 GMT

Hi,

Add a field to your script for tagging the target customers. Something like:

IF(CustomerID='123' or CustomerID='234' or CustomerID='456' or CustomerID='4598' or CustomerID='286' , 'TheOne') AS CustomerTag,

Use this field to filter your chart or table in the frontend.

Regards, Sander

filter in Diagram

Wed, 13 May 2009 01:52:03 GMT

Hi,

I will 5 Customer exclued from our Customer Tabel and select the Net Value in one Diagramm and in other Diagramm i will display the Net Value from all Customer.

is the formel right? can i the 5 Customer exclude in bookmark, if yes how?

IF(CustomerID is not '123' or CustomerID is not'234' or CustomerID is not'456' or CustomerID is not'4598' or CustomerID is not='286' , 'TheOne') AS CustomerTag,

Thanks

Regards

Shideh

filter in Diagram

Wed, 13 May 2009 05:39:15 GMT

Be careful, when your logic tests for "is not" or "not equal" you need to connect the tests with AND's not OR's. In your above code, CustomerID 234 is not '123' and therefore will pass. Actually, everything will pass when you use OR's.

John