topic Date with if statement in QlikView

Date with if statement

davyqliks — Sat, 16 Nov 2024 00:48:44 GMT

Hi Experts,

I hope you are all keeping safe and well.

I have 2 dates in my data load

Issue Date
Voucher Date

My calendar is powered by the Voucher Date.

Voucher date is created when an invoice is posted but i also need to include the Issue date in the model and so wanted to employ an if statement to capture Issue Date as Voucher Date if the voucher date is blank.

Here is my best (just realised not working ) effort.

Date(if(( len([Voucher Date])=0) or [Voucher Date]>0 ,[Voucher Date],[Issue date] ),'DD/MM/YYYY') as [Voucher Date],

Can anyone help to modify this to capture issue date as Voucher date when the voucher date is blank?

Thank you

Daniel

Re: Date with if statement

dplr-rn — Mon, 20 Apr 2020 14:52:36 GMT

your logic seems correct. try changing it to simple isnull() condition

if thats not working either i feel there maybe some other data coming in. maybe spaces.

Re: Date with if statement

davyqliks — Mon, 20 Apr 2020 15:27:55 GMT

Hi,

Thank you for this.

I am having trouble writing the load statement with the isnull() condition.

Please can you show in my example how you would add this as i am having issue getting syntax correct.

Thank you

Re: Date with if statement

dplr-rn — Mon, 20 Apr 2020 15:31:52 GMT

if( isnull([Voucher Date]) ,[Issue date] ,[Voucher Date])

Re: Date with if statement

davyqliks — Tue, 21 Apr 2020 09:45:33 GMT

Thank you,

This worked perfectly.

Stay safe out there

Daniel