topic Re: Problem with FieldValue in QlikView

Problem with FieldValue

Anonymous — Sat, 15 Aug 2015 13:02:54 GMT

Hi,

I would like to use the FieldValue function but I obtain a strange result: instead of 1, the result is a question mark... why?

This is my code:

Data:

load * Inline [

Num

4];

LOAD

FieldValue('Num', 1) as FirstNum

Resident Data;

Thanks,

Elena

Re: Problem with FieldValue

maximiliano_vel — Sat, 15 Aug 2015 13:26:12 GMT

Try

LOAD

Num(FieldValue('Num',1)) as FirstNum

RESIDENT Data;

Re: Problem with FieldValue

marcus_sommer — Sat, 15 Aug 2015 13:55:19 GMT

For some reasons couldn't qv create or interpret the string-representation for this field (there are other cases in which this happens, too) and therefore it displayed the "?" as placeholder. The suggestion from maximiliano.velez with num() or a dual() will solve it.

- Marcus

Re: Problem with FieldValue

Anonymous — Sat, 15 Aug 2015 17:23:50 GMT

Thank you guys.

The example above was just a test.... my aim is to use Rob Wunderlich's code below to get max value in order to improve performance:

LOAD

max(FieldValue('ID', recno())) as Maximum

AUTOGENERATE FieldValueCount('ID');

So, in your opinion, will I ever be able to use this function (I use QV 11 SR3?)? Is there a solution?

Elena

Re: Problem with FieldValue

marcus_sommer — Sat, 15 Aug 2015 17:58:44 GMT

The solution from Rob worked - I have used it several times, recently with QV 11 SR8 but I don't believe that there is an issue with SR3. What didn't worked like you expected it?

- Marcus

Re: Problem with FieldValue

Anonymous — Sat, 15 Aug 2015 18:33:26 GMT

My problem is that the result of the code below is a question mark

Dati:

load * Inline [

Numero

];

LOAD

max(FieldValue('Numero',RecNo())) as Maximum

AutoGenerate FieldValueCount('Numero');

Is there an error in my code? Do I have to do some settings in the document properties?

Elena

Re: Problem with FieldValue

maximiliano_vel — Sat, 15 Aug 2015 18:50:50 GMT

You could use the same approach i mentioned above

Dati:

load * Inline [

Numero

];

LOAD

max(Num(FieldValue('Numero',RecNo()))) as Maximum

AutoGenerate FieldValueCount('Numero');

Re: Problem with FieldValue

marcus_sommer — Sun, 16 Aug 2015 07:38:09 GMT

Like above mentioned qlikview failed by the string-interpretation which normally worked automatically. Therefore you need to create these string-interpretation with function which automatically create a dual-field like formatting-functions like num() or you used dual() itself. A quite similar case is here loading a field with distinct values and it worked with dual().

- Marcus