topic Re: How to show date values based on condition? in QlikView

How to show date values based on condition?

Tue, 05 May 2015 15:52:10 GMT

Hi,

I want to show Dates when the below condition satisfy

when DateA is blank the expression should show DateB value other wise it should show DateA value. I have used below seems not working.

=Date(If((DateA='',DateB,DateA),'DD/MM/YYYY')

Please can anyone suggest me how to change this.

Thanks.

buzzy996 — Tue, 05 May 2015 15:56:24 GMT

try tis way,

=Date#(If(isnull(DateA),DateB,DateA),'DD/MM/YYYY')

jpenuliar — Tue, 05 May 2015 15:56:43 GMT

Hi Amelia,

Depends on your field whether Blank(empty) or Null.

see which apply to your case:

Len(DateA) = 0 or Isnull(DateA)

Tue, 05 May 2015 15:58:50 GMT

Thanks. working.

buzzy996 — Tue, 05 May 2015 16:07:13 GMT

ur wc