Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date generating issues

Hi buddy,

I have a two dates fields based on that i'm generating dates difference between them by using interval match.Now the problem it will generate nulls values in that field. my requirement is where ever the null values i need to replace with Task_close_at filed date.Please help me out.PFACapture.JPG

3 Replies
petter
Partner - Champion III
Partner - Champion III

You are trying to use IntervalMatch() with a interval table that has undefined (null) values for the end date (task_closed_at). That leads to null values for Link Date. If you set task_closed_at in the PENDING table while loading it to some future date then you will remove these nulls and the following IntervalMatch() should be alright.

ecolomer
Master II
Master II

It does not really know how you want to handle the case you raise. What output you expect?

try with:

if(IsNull([Link Date]), task_closed_at, [Link Date])

petter
Partner - Champion III
Partner - Champion III

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.


Filling nulls