topic Re: Date is missing in QlikView

Date is missing

prma7799 — Fri, 13 Mar 2015 03:55:41 GMT

Hi All,

When i am using (alt(Date#(F2,'MMM DD'),Date(F2,'DD MMM')) as Date)

then my one date is missing.

Can anybody tell me where i was wrong in ALT function

Thanks
PM

Re: Date is missing

prma7799 — Fri, 13 Mar 2015 03:57:02 GMT

PFA

Re: Date is missing

its_anandrjs — Fri, 13 Mar 2015 04:01:04 GMT

Hi,

Use properly date functions in the Alt, If convert it into proper date num date format by using Date# then use Date to convert it into date format. See the example below from QV Help.

Ex:-

alt(

date#( dat , 'YYYY/MM/DD' ),

date#( dat , 'MM/DD/YYYY' ),

date#( dat , 'MM/DD/YY' ),

'No valid date' )

Or may be your date is not in proper date format check it.

Regards

Anand

Re: Date is missing

prma7799 — Fri, 13 Mar 2015 04:04:16 GMT

Hi Anand,

When I am using below my alt function then output is coming accept jan3 date.

Thanks

Re: Date is missing

its_anandrjs — Fri, 13 Mar 2015 04:05:08 GMT

Hi,

Try this

(alt(Date#(F2,'MMM DD'), Date(Date#(F2,'DD MMM'),'DD MMM') ) as Date)

Regards,

Anand

Re: Date is missing

prma7799 — Fri, 13 Mar 2015 04:10:35 GMT

Hi ,

in this jan3 is missing and when I am using

alt(date#( F2 , 'MMM DD' ),date#( F2 , 'DD/MMM' ),date#( F2 , 'DD/MMM' ) ) as 1 ,

then jan3 is coming but it is showing me left side in list box.

Thanks

Re: Date is missing

prma7799 — Fri, 13 Mar 2015 04:40:41 GMT

Re: Date is missing

Anonymous — Fri, 13 Mar 2015 05:06:16 GMT

Try this

alt(date#( F2 , 'MMM DD' ),date#( F2 , 'MMMDD' ),date#( F2 , 'DD/MMM' ),date#( F2 , 'DD/MMM' ) ) as 1

Re: Date is missing

agni_gold — Fri, 13 Mar 2015 05:07:00 GMT

Try this , this will help you ....

alt(Date#(trim(Left(F2,3))&' '& trim(Mid(F2,4,3)),'MMM DD'), Date(Date#(trim(Left(F2,3))&' '& trim(Mid(F2,4,3)),'DD MMM'),'DD MMM') ) as Date

Re: Date is missing

Fri, 13 Mar 2015 05:07:21 GMT

Hi prashantbi

The Jan3 reading as text see carefully all filed having some space Month and Date but only jan3 there is no space

do one thing give some space in source file for jan3 or else by using some qlikview function to give space

thanks

Manju

Re: Date is missing

PrashantSangle — Fri, 13 Mar 2015 05:09:08 GMT

Hi,

Try like

alt(Date#(F2,'MMM DD'),

Date(F2,'DD MMM'),

Date#(F2,'MMMD'),

Date(F2,'MMMD')

) as Date

Regards

Re: Date is missing

tamilarasu — Fri, 13 Mar 2015 05:14:42 GMT

Hi Prashantbi,

Jan3 is not a valid format. Just give space between date and month. i.e jan 3.

Below solution works for your data.. Just try this.

alt(Date#(F2,'MMM DD'),Date#(F2,'DD MMM'),Date#( F2 , 'MMMDD' ))

Re: Date is missing

agni_gold — Fri, 13 Mar 2015 05:18:16 GMT

Date#

(trim(Left(F2,3))&' '& trim(Mid(F2,4,3)),'MMM DD') as

Date_123

you can also try this

Re: Date is missing

jonathandienst — Fri, 13 Mar 2015 05:19:13 GMT

You have 3 different date formats, so you need 3 parts to your Alt():

Date(alt(Date#(F2,'MMM DD'), Date(F2,'DD MMM'), Date#(F2,'MMMDD'))) as Date

Re: Date is missing

agni_gold — Fri, 13 Mar 2015 05:20:00 GMT

Re: Date is missing

prma7799 — Fri, 13 Mar 2015 05:29:28 GMT

Hi Greeshma,

No need to write above full expression I used only

alt(date#( F2 , 'MMM DD' ),date#( F2 , 'MMMDD' )), 'MM/DD/') function