topic Null Value in QlikView

Null Value

Tue, 15 May 2012 09:34:37 GMT

Hi all,

How can i load data without null values

SRS

Jason_Michaelides — Tue, 15 May 2012 11:25:44 GMT

Maybe put WHERE IsNull(YourField)=0 in your load statement?

kaushiknsolanki — Tue, 15 May 2012 11:31:52 GMT

HI,

You can achieve this in this way.

Load * from ABC where not isnull(Field1);

Here Field1 is the field from which you dont want the null data.

Regards,

Kaushik Solanki

Tue, 15 May 2012 11:35:09 GMT

Hi,

Load * from Table_Name where Field_Name <> ' ' ;

Hope it helps

Regards

Ravikumar