Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.