topic Re: If statement scripting help in QlikView

If statement scripting help

has75042 — Wed, 25 Nov 2020 16:16:04 GMT

I have a if statement

if (STATUS = '2', date(Date#(DAT,'YYMMDD')) ,null()) as Status_Date,

However, I need to add another date format date(Date#(DAT,'YYYYMMDD')) in the else condition.

Is it possible?

Any help would be appreciative.

Re: If statement scripting help

Vegar — Thu, 07 Nov 2019 21:49:57 GMT

Consider this example script:

LOAD *, if (STATUS = '2', date(Date#(DAT,'YYMMDD')) ,date(Date#(DAT,'YYYYMMDD'))) as Status_Date inline [ ID, STATUS, DAT, AMOUNT 1, 2, 160101, 10 2, 1, 20160101, 11 3, 2, 191231, 12 4, 1, 20191231, 14 ];

Re: If statement scripting help

has75042 — Thu, 07 Nov 2019 22:35:28 GMT

This is my actual script

if( STATUS = '3', date(Date#(DAT,'YYYYMMDD')) ,
if (STATUS = '5',date(Date#(DAT,'YYYYMMDD')) ,
if(STATUS = '2', date(Date#(DAT,'YYMMDD')),
if(STATUS = '4', date(Date#(DAT,'YYYYMMDD')) ,null())))) as Status_Date,

I need to add two difference date format in then condition for status =2

Re: If statement scripting help

Vegar — Fri, 08 Nov 2019 05:22:39 GMT

I'm sorry, but I don't understand. What's the issue with your if statement? Why does it not suit your needs? Please explain. Maybe you can give us a sample of input data together with a description of the expected output.

Re: If statement scripting help

has75042 — Fri, 08 Nov 2019 14:50:58 GMT

Sorry for the confusion.

The issue I have is that I have two different date format for status 2

One format is in 'YYMMDD' and another one is in 'YYYYMMDD'. Please see the attached pic

The logic is breaking because then condition for status 2 is only looking for this date format 'YYMMDD'. I want it to look for both format 'YYMMDD and 'YYYYMMDD'

if(STATUS = '2', date(Date#(DAT,'YYMMDD')),

Hope this make some more sense.

Re: If statement scripting help

Vegar — Mon, 11 Nov 2019 15:59:54 GMT

Do you really need to look for status 2? What if you do like this instead? First look for YYYYMMDD and if that does not return any value then try to look for YYMMDD.

LOAD *, ALT(date(Date#(DAT,'YYYYMMDD')),date(Date#(DAT,'YYMMDD'))) as Date, //if (STATUS = '2', date(Date#(DAT,'YYMMDD')) ,date(Date#(DAT,'YYYYMMDD'))) as Status_Date inline [ ID, STATUS, DAT, AMOUNT 1, 2, 160101, 10 2, 1, 20160101, 11 3, 2, 191231, 12 4, 1, 20191231, 14 ];

Re: If statement scripting help

Brett_Bleess — Tue, 12 Nov 2019 19:58:52 GMT

Has, did Vegar's final post get you what you needed? If so, please be sure to come back to the post and use the Accept as Solution button on that post to give him credit and let others know did what you needed. If you are still working on things, please leave an update.

Regards,
Brett