Fieldindex and fieldvalue. with duplicates

[#1]

Hi,

I create a qvw document in wich I have a XML_data that has a localication data to be configurate un my doc.... This table has two rows lockey(localization key) and en_us (value of the key)....

lockey   en_us

lbl1         hello

lbl2         bye

lbl3         hello

lbl4         guess

ok i think whe I use Field value funtion duplicates are deleted in en_us col..... when my doc is reloaded, the lbl3 is loaded with the value of lbl4

I found these inf: http://community.qlik.com/message/154033 butt only and peek functions doesn't work in the text object properties...

thanks k

[kuba_michalik · Accepted solution]

The duplicates are not deleted, but fieldvalue/fieldindex functions do refer only to distinct values.

All chart functions can work in text object properties. In your case, =Only({1<locKey={'lbl3'}>}en_value) should give you what you need, unless lbl3 has more than one distinct, non-missing en_value associated. Please see the attached qvw.

[#3]

Thanks Kuba, only function works perfect.