topic fill in missing values in QlikView

fill in missing values

Anonymous — Mon, 30 May 2011 08:43:34 GMT

Hi,

I have a date field in my table but not every row has a date. For those rows that doesn't have a date i want them to have todays date.

How do i do this? It has to be done in the script.

Thanks!

Mon, 30 May 2011 08:51:39 GMT

Hi,

If you take the data from a sql query, you can use the NVL function. Otherwise, use;

if(isnull(field) = -1, today(), field)

Anonymous — Mon, 30 May 2011 08:53:09 GMT

Annika,

If the values without dates are null values you can do the following in the script:

Load

Date,

if(Len(Date)=0, Today(), Date) as NewDateField

From xxx..

Anonymous — Mon, 30 May 2011 08:56:14 GMT

Thank you Guys!

Just what i needed!

//A.