Fieldvalue shows ok in QlikView but not in access point

[Michiel_QV_Fan]

I use a fieldvalue to generate 5 custom headers in a straight table.

These show correct in QlikView but not in the access point.

This is the used syntax for the headers: =FieldValue('Interval openstaand', '1')  -> (1 to 5)

and this is the expression in the column: sum({<%Key_invoice_details_openstaand = {'1'}>}[Openstaand factuurbedrag]) -> (1 to 5)

In my current data set only has value 1, 4 and 5.

The data however is shifted to a earlier column (Fieldvalue 4 is shown in column where expression value = 2)

Using QlikView 11.20 SR10

Thanks!

[marcus_sommer]

Fieldvalue() will return the items from the field in load-order and maybe this had changed. I think you should force a certain order by loading within the script and you will be only predictable results if the queried field no key-field.

- Marcus

[Michiel_QV_Fan]

Marcus,

thanks. It's not a load sequence issue. I tested with this syntax: (FieldValue('Helptext',FieldIndex('Name', 'John Doe')))

found in this post Missing Manual - FieldIndex()

That gives me the desired results, but because 2 and 3 have no data I do not have headers filled with data .... I overlooked that.

I need to change the headers to the transalation file.