topic How to Remove Zeros Value Records in QlikView

How to Remove Zeros Value Records

Sun, 15 Jan 2017 15:53:52 GMT

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

Re: How to Remove Zeros Value Records

girirajsinh — Sun, 15 Jan 2017 16:23:51 GMT

Where Clause in Load

Where Amount <>0 and MTD <>0;

Try that

Re: How to Remove Zeros Value Records

vinieme12 — Sun, 15 Jan 2017 17:36:28 GMT

LOAD *

FROM YourSource

Where Amount>0 and MTD>0;

Re: How to Remove Zeros Value Records

swuehl — Sun, 15 Jan 2017 19:47:49 GMT

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?

Re: How to Remove Zeros Value Records

Mon, 16 Jan 2017 05:59:54 GMT

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