topic Re: Date funciton - to be flexible in loading data in QlikView

Date funciton - to be flexible in loading data

Thu, 18 Apr 2013 12:12:31 GMT

load entity,

Client

From

i am uploading data from above excel file on shared drive, but i need date to be flexible as each day the name of file will change to T-2 business date. Could anyone please help in letting me know the possible solution

Re: Date funciton - to be flexible in loading data

alexandros17 — Thu, 18 Apr 2013 12:31:48 GMT

Let myDate = text(num(day(today()),'00')) & text(num(month(today()),'00')) & text(num(year(today()),'0000'))

Let myFile = ''

...

load

...

from $(myFile)

hope it helps

Re: Date funciton - to be flexible in loading data

Thu, 18 Apr 2013 12:48:56 GMT

thanks for prompt response.

but i am using

let myDate = text(if(left(weekday(today()-2),1)='S'.Date(Today()-4,'MMDDYYYY'),Date(Today()-2,'MMDDYYYY')));

as my excel file for today will be always 2 days old and i have to ignore weekends also.

but it gave a load error.

please advise

Re: Date funciton - to be flexible in loading data

Thu, 18 Apr 2013 12:49:46 GMT

thanks for prompt response.

but i am using

let myDate = text(if(left(weekday(today()-2),1)='S'.Date(Today()-4,'MMDDYYYY'),Date(Today()-2,'MMDDYYYY')));

as my excel file for today will be always 2 days old and i have to ignore weekends also.

but it gave a load error.

please advise

Re: Date funciton - to be flexible in loading data

Thu, 18 Apr 2013 12:50:26 GMT

thanks for prompt response.

but i am using

let myDate = text(if(left(weekday(today()-2),1)='S'.Date(Today()-4,'MMDDYYYY'),Date(Today()-2,'MMDDYYYY')));

as my excel file for today will be always 2 days old and i have to ignore weekends also.

but it gave a load error.

please advise

Re: Date funciton - to be flexible in loading data

alexandros17 — Thu, 18 Apr 2013 12:55:00 GMT

Send me the error ...

Re: Date funciton - to be flexible in loading data

Thu, 18 Apr 2013 12:56:12 GMT

Hey Alex,

i got the answer...

thanks a lot