Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Filling nulls

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 "

1.PNG

Tags (3)
1 Solution

Accepted Solutions

Re: Filling nulls

Hi,

Have a look at the attached application.

Regards,

Kaushik Solanki

Regards,
Kaushik Solanki

View solution in original post

8 Replies

Re: Filling nulls

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

Regards,
Kaushik Solanki
Not applicable

Re: Filling nulls

Its not working the same result with nulls.

qlikviewnovice
Valued Contributor II

Re: Filling nulls

Hi,

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

Not applicable

Re: Filling nulls

No,but its giving same results what i have

Re: Filling nulls

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik Solanki
Not applicable

Re: Filling nulls

PFA of pending.xls

Re: Filling nulls

Hi,

Have a look at the attached application.

Regards,

Kaushik Solanki

Regards,
Kaushik Solanki

View solution in original post

MVP
MVP

Re: Filling nulls

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