topic Re: Fieldvalue with variables in QlikView

Fieldvalue with variables

jorgelardi — Wed, 25 Nov 2020 16:16:04 GMT

I want to use fieldValue as follows:

fieldvalue ('Field' variable) where registration of the field is calculated from a variable calculated from the user's selection

It's not working me. Question: fieldValue works with variables?

Thank you

Re: Fieldvalue with variables

rubenmarin — Mon, 07 Mar 2016 18:16:33 GMT

Hi Jorge,

'variable' is used to complete the field name? In that case you can use:

=FieldValue('Field$(variable)',ValueNumber)

Re: Fieldvalue with variables

Saravanan_Desingh — Mon, 07 Mar 2016 18:23:39 GMT

Please check the attachment. I have come up with an example.

Re: Fieldvalue with variables

jimbeierschmitt — Thu, 14 Apr 2016 19:16:07 GMT

In your example the field value function works as defined. It's referencing the original load order of the field values. If you sort the table in the load script the field value function will follow.