topic Re: Fieldindex and fieldvalue. with duplicates in QlikView

Fieldindex and fieldvalue. with duplicates

Tue, 23 Apr 2013 22:05:40 GMT

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

Re: Fieldindex and fieldvalue. with duplicates

kuba_michalik — Wed, 24 Apr 2013 08:24:47 GMT

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.

Re: Fieldindex and fieldvalue. with duplicates

Wed, 24 Apr 2013 20:08:38 GMT

Thanks Kuba, only function works perfect.