topic Re: Alt() function giving output as Null in text object? in QlikView

Alt() function giving output as Null in text object?

Wed, 10 Jun 2015 10:42:11 GMT

Hi ,

Im trying Alt() function in text object but it is giving null in output.

I have 3 different date formats in excel and want to make dates only in one format using alt().

How to do this?

I have attached my qvw file.Please check it .

Thanks in advance.

Re: Alt() function giving output as Null in text object?

qlikmsg4u — Wed, 10 Jun 2015 10:46:29 GMT

Text box holds only one value,not individual rows.

try this

=date(Alt(

Date#(MixDate,'MM/DD/YY'),

Date#(MixDate,'MM-DD-YYYY'),

Date#(MixDate,'DD-MM-YYYY')

),'DD-MM-YYYY')

select one date from list box

Re: Alt() function giving output as Null in text object?

swuehl — Wed, 10 Jun 2015 10:46:48 GMT

I think your first argument's date format needs to be adapted to your data set, and an additional Date() function reformats to a common default format:

=Date(

Alt(

Date#(MixDate,'M/DD/YY'),

Date#(MixDate,'MM-DD-YYYY'),

Date#(MixDate,'DD-MM-YYYY')

))

This works in your text box, when you select a single field value.

Re: Alt() function giving output as Null in text object?

PrashantSangle — Wed, 10 Jun 2015 10:47:25 GMT

Hi,

Try this,

=date(Alt(

Date#(MixDate,'MM/DD/YY'),

Date#(MixDate,'MM-DD-YYYY'),

Date#(MixDate,'DD-MM-YYYY')

),'DD-MM-YYYY')

Regards

Re: Alt() function giving output as Null in text object?

satishkurra — Wed, 10 Jun 2015 10:50:08 GMT

PFA

Re: Alt() function giving output as Null in text object?

sushil353 — Wed, 10 Jun 2015 10:50:36 GMT

Hi,

Alt function will return the valid number representation. in your case all the no format are valid so that is why it will give all the formats based on the selection. you can visualize that as

=concat(Alt( Date#(MixDate,'DD/MM/YY'),
Date#(MixDate,'MM-DD-YYYY'),
Date#(MixDate,'DD-MM-YYYY')
),' ')

USE Date(Alt( Date#(MixDate,'DD/MM/YY'),
Date#(MixDate,'MM-DD-YYYY'),
Date#(MixDate,'DD-MM-YYYY')
))

Re: Alt() function giving output as Null in text object?

Wed, 10 Jun 2015 11:00:32 GMT

Thanks Max dreamer .Its working.

Re: Alt() function giving output as Null in text object?

PrashantSangle — Wed, 10 Jun 2015 11:01:48 GMT

Welcome

Regards