topic Re: How to add a dynamic elem_no to FieldValue() in QlikView

How to add a dynamic elem_no to FieldValue()

Thu, 16 Feb 2017 15:29:49 GMT

Hi guys

Yet again, I seek your collective wisdom. 😃

I want to use the function FieldValue() and have used it thus: =FieldValue([FIELDNAME], 1), which returns the field value for the first row in the load order (elem_no=1). However, what I would like is to provide the elem_no dynamically, i.e., when I select another field, get the rownumber (or elem_no) of that value and get the fieldvalue of another field. In pseudo code: =FieldValue([FIELDNAME1], elem_no(FIELDNAME2)). Is this possible?

Thanks again for your time!

//Nathalie

Re: How to add a dynamic elem_no to FieldValue()

sunny_talwar — Thu, 16 Feb 2017 15:41:30 GMT

Where exactly are you using this FieldValue() function?

Re: How to add a dynamic elem_no to FieldValue()

Carlos_Reyes — Fri, 17 Feb 2017 03:59:42 GMT

I think you can use FieldIndex for that... something like:

FieldValue('City',FieldIndex('Country',Only(Country)))

Review the enclosed file for the example.

Re: How to add a dynamic elem_no to FieldValue()

sdmech81 — Fri, 17 Feb 2017 06:03:12 GMT

Something like this:

=FieldValue('[FIELDNAME1]',FieldIndex('[FIELDNAME2]',[FIELDNAME2)])

index takes 2 values and returns number based on load order..

Share sample/appliction