Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Fieldindex and fieldvalue. with duplicates

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

text.png

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

1 Solution

Accepted Solutions
kuba_michalik
Contributor III

Re: Fieldindex and fieldvalue. with duplicates

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.

2 Replies
kuba_michalik
Contributor III

Re: Fieldindex and fieldvalue. with duplicates

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.

Not applicable

Re: Fieldindex and fieldvalue. with duplicates

Thanks Kuba, only function works perfect.

Community Browser