topic Excluding with where in QlikView

Excluding with where

Thu, 05 Apr 2012 06:12:41 GMT

Dear Community,

I would like to exclude whith "where" all the materials which started by 4and 5. I have no idea how to do this. Here is my actually coding but it doesn't work :

[..\..\SOURCES\SAP\ERP\MARA_MATERIAL_MASTER.qvd](qvd)WHERE Material_MATNR <> '4*' and Material_MATNR <> '5*';

Could anyone help me?

Thanks!!!

Excluding with where

vijay_iitkgp — Thu, 05 Apr 2012 06:46:36 GMT

Hi,

If you want to remove all rows when Material_MATNR started with 4 or 5 the use:

Where Not Wildmatch(Left(Material_MATNR,1),'4','5') ;

Where Wildmatch(Left(Material_MATNR,1),'4','5') =0;

Hope this will help

Excluding with where

CELAMBARASAN — Thu, 05 Apr 2012 08:46:07 GMT

Hi,

Change this part

WHERE Material_MATNR <> '4*' and Material_MATNR <> '5*';

WHERE Not WildMatch(Material_MATNR, '4*' ,'5*');

WHERE WildMatch(Material_MATNR, '4*' ,'5*')>0;

Celambarasan

Re: Excluding with where

Tue, 10 Apr 2012 09:31:02 GMT

Hello Vijay Singh,

sorry that I reply so late, but I was not in the company. Your answer is absolutely wright and your soultion worked. I hope that you get your 10 points. Thanks a lot!!

Mit freundlichen Grüßen/ Best regards

Walter

Re: Excluding with where

Tue, 10 Apr 2012 09:32:14 GMT

Hello Celambarasan,

sorry that I reply so late, but I was not in the company. Your answer is absolutely wright and your soultion worked. I hope that you get your 10 points. Thanks a lot!!

Mit freundlichen Grüßen/ Best regards

Walter

Excluding with where

SunilChauhan — Tue, 10 Apr 2012 09:55:48 GMT

try below code

where Material_MATNR <>if(findoneof(Material_MATNR ,'45'),Material_MATNR );

hope this helps

Excluding with where

SunilChauhan — Tue, 10 Apr 2012 09:57:30 GMT

or try this code

where Material_MATNR <>if(findoneof(Material_MATNR ,'4*'),Material_MATNR ) and sale<>if(findoneof(Material_MATNR ,'5*'),Material_MATNR );

hope this helps

Excluding with where

Tue, 10 Apr 2012 11:52:24 GMT

Hello Sunil Chauhan,

thanks a lot for your helpful answer and I would like to give you 5 points. The problem at your solution is, that all materials with a 4 or 5 will be excluded. For example: A material 100020512 will not be shown because of the 5 in it. Please watch the other solutions, they are correct. But really thank you very much for your proffessional reply.

Greetings

Walter