Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

stabben23
Honored Contributor

Is null handling with 3 dates

Hi,

I have a problem: this is my table

2014-06-16_0814.png

This should be handled in this way, pseudocode:

if(isnull(date1),date2,date1) and if( isnull(date1 and date 2),date3) as Finaldate

I do this in the script, does anyone have a quick solution?

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Re: Is null handling with 3 dates

use alt function.

5 Replies
Not applicable

Re: Is null handling with 3 dates

Explore Alt function.

Not applicable

Re: Re: Is null handling with 3 dates

use alt function.

stabben23
Honored Contributor

Re: Is null handling with 3 dates

Hi Ramkumar,

the alt function was the trick,

thanks a lot for really quick answer.

Not applicable

Re: Is null handling with 3 dates

Suppose every date field has 6 digits, then you can try this expression: Left(date1 & date2 & date3, 6)

stabben23
Honored Contributor

Re: Is null handling with 3 dates

works in my testcase but that is not a stable solution.

Community Browser