How to Remove Zeros Value Records

[#1]

Hi All

I want to remove the records where Amount and MTD  Field having zeros values .Please suggest me a way to remove zeros in Qlikview script.

Please find attached snapshot for your reference.

Regards

Deepak

[girirajsinh]

Where Clause in Load

Where Amount <>0 and MTD <>0;

Try that

[vinieme12]

LOAD *

FROM YourSource

Where Amount>0 and MTD>0;

[swuehl · Accepted solution]

Or maybe

LOAD *

FROM YourSource

Where Not (Amount=0 And MTD=0);

or alternatively

LOAD *

FROM YourSource

Where Amount<>0 Or MTD<>0;

The correct WHERE clause will depend on your exact requirement, do you require any or both field values of Amount and MTD field to be zero to remove the record?

[#5]

Hi Stefan,Vineeth,Girirajsinh

Thanks for reply. But In my soure data both the fields having negative values so I can not put >0  Condition 

LOAD *

FROM YourSource

Where Amount<>0 Or MTD<>0;

and above condition I have tried it After putting this condition even I am not getting any data.

and this below condition which is shared by Stefan worked for me ...

LOAD *

FROM YourSource

Where Not (Amount=0 And MTD=0);

Thanks Stefan ,Vineeth and Girirajsinh !!

Regards

Deepak