Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

leni_balakrishn
Contributor III

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

Tags (1)
3 Replies
Not applicable

Re: Issue in getting value using Fieldvalue

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

Re: Issue in getting value using Fieldvalue

Tb1:

 

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

          SQL SELECT  VALID_FROM

          FROM XXX

          WHERE CODE= 'aaaa';

leni_balakrishn
Contributor III

Re: Issue in getting value using Fieldvalue

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