creating new date field based on other field values

[dseelam]

Hello Qlik Folks,

Please help

PO Issue Date :

I have 3 fields -document type, PO creation date, PO Release date.

depending on document type  create a new date field  PO Issue Date

If document type=Standard document, use PO creation date.

If document type=Blanket Release document, use PO Release date.

If document type= Blanket document, use NULL value. to create PO Issue Date 

Thanks,

D

[VishalWaghole · Accepted solution]

Try below expression,

If(match(Document type,Standard document), PO creation date,
If(match(Document type,Blanket Release document), PO Release date,
If(match(Document type,Blanket document), null()))) as PO Issue Date

Hope this will work for you.

Regards,
Vishal Waghole

[dseelam]

Thank you Vishal