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: 
Anonymous
Not applicable

Issue in getting value using Fieldvalue

Hi All,

Below is the load statement I am using to get the first value from the table but I am not getting the appropriate value.

Tb1:

 

load date(floor(VALID_FROM)) as ValidFrom;

          SQL SELECT Max(VALID_FROM) as VALID_FROM

          FROM XXX

          WHERE CODE= 'aaaa';

let LastDate = FieldValue('ValidFrom',1);

Please help me to get this work

ValidFrom has value 2013-12-28 but LastDate has 1905-05-23

Thanks,

Leni Balakrishnan

3 Replies
Not applicable
Author

Hi,

You can try writing the expression:

          =DATE(LastDate, 'YY/MM/DD')

I was facing a similar issue, but it was resolved when I used this expression while displaying the value in my listbox.

Hope this helps.

Not applicable
Author

Tb1:

 

load  max(date(floor(VALID_FROM))) as ValidFrom;

          SQL SELECT  VALID_FROM

          FROM XXX

          WHERE CODE= 'aaaa';

Anonymous
Not applicable
Author

Hi All,

I just did a mistake.

I tried to show that variable in textbox so when I replaced let with set it worked.

Thanks all for your help