topic Re: Interesting behavior of IF in QlikView

Interesting behavior of IF

Tue, 22 Jan 2013 16:11:56 GMT

if I write in my loading script:

if(1=1, "MyDateTimeField")

as _wojzehDateTime,

then I get:

if I add the second argument:

if(1=1, "MyDateTimeField", null())

as _wojzehDateTime,

if(1=1, "MyDateTimeField",0)

as _wojzehDateTime,

if(1=1, "MyDateTimeField", '')

as _wojzehDateTime,

then I get:

Nicole-Smith — Tue, 22 Jan 2013 16:16:11 GMT

If you want them all formatted as Date/Time, you should use:

if(1=1, timestamp("MyDateTimeField")) as _wojzehDateTime,

if(1=1, timestamp("MyDateTimeField"), null()) as _wojzehDateTime,

if(1=1, timestamp("MyDateTimeField"),0) as _wojzehDateTime,

if(1=1, timestamp("MyDateTimeField"), '') as _wojzehDateTime,

Tue, 22 Jan 2013 16:18:56 GMT

Thank you Nicole!

Looks like the second argument does not define the final result formatting but the first does.