Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Null Value

Hi all,

How can i load data without null values

SRS

Tags (1)
3 Replies
jason_michaelid
Honored Contributor II

Null Value

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

Null Value

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

Not applicable

Re: Null Value

Hi,

Load * from Table_Name where Field_Name <> ' ' ;

Hope it helps

Regards

Ravikumar