Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last 1 date is not retrieving

Hello,

I'm trying to retrive the last one date data only. But i'm not able to retrive it. Can anyone help me.

Code which i'm using is

Temp_CT_VQDIndividual:

LOAD Date

FROM

Date.xls

(biff, embedded labels, table is Sheet1$);

IndividualMaxDate:

Load Max(Date) as MaxDate

Resident Temp_CT_VQDIndividual;

Let vIndividualMaxCapDate=Peek('MaxDate',-1,IndividualMaxDate);

DROP Table IndividualMaxDate;

DROP Table Temp_CT_VQDIndividual;

T1:

LOAD Date

FROM

Date.xls

(biff, embedded labels, table is Sheet1$)

Where

Date > Date($(vIndividualMaxCapDate)-(1))

;

Here i'm attaching my file it may helps u.

1 Solution

Accepted Solutions
derekjones
Creator III
Creator III

Here you go, solution attached. Essentially your need to add a date(floor(Date)) around the variable.

Hope this helps. Have a good weekend!

Derek

View solution in original post

4 Replies
derekjones
Creator III
Creator III

Hi Jacq

Works perfectly fine on mine (see attached). But I did create my own date.xls file, do you have your excel file you can send? I think it may simply be a formatting issue on the date in your excel file we need to handle.

Derek

Not applicable
Author

For your reference i'm attaching my excel file..

derekjones
Creator III
Creator III

Here you go, solution attached. Essentially your need to add a date(floor(Date)) around the variable.

Hope this helps. Have a good weekend!

Derek

Not applicable
Author

Thanks a lot derekjones It's working...

Where

Date(floor(Date)) >= Date($(vIndividualMaxCapDate))

The keyworkd Floor helped us..