topic Issue in getting value using Fieldvalue in QlikView

Issue in getting value using Fieldvalue

Anonymous — Tue, 19 Mar 2013 05:18:15 GMT

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

Tue, 19 Mar 2013 05:33:05 GMT

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.

Tue, 19 Mar 2013 06:38:11 GMT

Tb1:

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

SQL SELECT VALID_FROM

FROM XXX

WHERE CODE= 'aaaa';

Anonymous — Tue, 19 Mar 2013 10:32:15 GMT

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