topic Re: Filling nulls in QlikView

Filling nulls

Mon, 24 Aug 2015 17:16:32 GMT

Hi All,

I have a link table with nulls i need to replace with actual date.

"Link Date nulls to be replaced with Task_closed_at "

Re: Filling nulls

kaushiknsolanki — Mon, 24 Aug 2015 17:32:41 GMT

Hi,

Change your script part to below.

Temp2:

Load *,num(interval(task_closed_at-[Link Date]),'#,##0') as age;

Load *,

//task_closed_at,

//if(isnull(task_opened_at), task_closed_at,task_opened_at) as task_opened_at,

if(Isnull([Link Date]),task_closed_at,[Link Date]) as [Link Date],

task_opened_at,

task_closed_at

Resident Temp;

Regards,

Kaushik Solanki

Re: Filling nulls

Tue, 25 Aug 2015 01:01:02 GMT

Its not working the same result with nulls.

Re: Filling nulls

Anonymous — Tue, 25 Aug 2015 01:15:51 GMT

Hi,

Are you getting any error message if you follow Kaushik Script?

Re: Filling nulls

Tue, 25 Aug 2015 03:53:46 GMT

No,but its giving same results what i have

Re: Filling nulls

kaushiknsolanki — Tue, 25 Aug 2015 03:58:18 GMT

Hi,

Kindly upload the PENDING.xls file so that I can reload the application and check the issue.

Regards,

Kaushik Solanki

Re: Filling nulls

Tue, 25 Aug 2015 04:02:48 GMT

PFA of pending.xls

Re: Filling nulls

kaushiknsolanki — Tue, 25 Aug 2015 04:25:40 GMT

Hi,

Have a look at the attached application.

Regards,

Kaushik Solanki

Re: Filling nulls

petter — Tue, 25 Aug 2015 05:06:01 GMT

This seems to be a cross-post of exactly the same issue on the same application made by two different members... Really strange. Please don't cross post - it waste a lot of time for others trying to help and it is very disrespectful.

Date generating issues