topic Re: Is null handling with 3 dates in QlikView

Is null handling with 3 dates

stabben23 — Mon, 16 Jun 2014 06:27:05 GMT

Hi,

I have a problem: this is my table

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?

Mon, 16 Jun 2014 06:27:52 GMT

Explore Alt function.

Mon, 16 Jun 2014 06:29:53 GMT

use alt function.

stabben23 — Mon, 16 Jun 2014 06:33:40 GMT

Hi Ramkumar,

the alt function was the trick,

thanks a lot for really quick answer.

Mon, 16 Jun 2014 07:17:11 GMT

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

stabben23 — Mon, 16 Jun 2014 08:25:01 GMT

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