topic Handle Null values while data loading in QlikView

Handle Null values while data loading

Anonymous — Thu, 15 Feb 2018 06:01:27 GMT

I want to know how to pass some value like 0 or NA to the fields while loading the data in QlikView or QS (in script), I don't want to avoid those records, I need them. @HIC

@Henric Cronstrom , Could you please reply.

Re: Handle Null values while data loading

karthikoffi27se — Thu, 15 Feb 2018 06:17:29 GMT

Hi Ankita,

You need to set a valyue for null

NULLASVALUE *;

SET Nullvalue = '<Null>';

Many Thanks

Karthik

Re: Handle Null values while data loading

tresB — Thu, 15 Feb 2018 06:21:19 GMT

HIC has already explained it here : NULL handling in QlikView very nicely.