topic An alternative for Fieldvalue in QlikView

An alternative for Fieldvalue

Tue, 08 Dec 2015 11:53:23 GMT

Hi Community!

I desperately need your help.

I have a table with 2 column Id and Description. I want to return in a text box the Description when the Id = v_Value (contains one of the Ids in the table).

Meaning, I do not want to filter the table with the Id value.

I looking for something like Peek function that can be used in an expression and not the script.

I tried Fieldvalue() but it returns a random description value.

Any suggestions?

Thanks you!!

Hila.

Re: An alternative for Fieldvalue

sunny_talwar — Tue, 08 Dec 2015 11:55:55 GMT

What about using Only() with set analysis?

=Only({<Id = {'v_Value'}>}Description)

Re: An alternative for Fieldvalue

marcus_sommer — Tue, 08 Dec 2015 11:58:20 GMT

If you have only one active ID something like only(Description) will work. Fieldvalue returned the values in load-order - if you couldn't catch them in this way you need a combination of fieldvalue and fieldindex.

- Marcus

Re: An alternative for Fieldvalue

Anonymous — Tue, 08 Dec 2015 12:00:10 GMT

Try Only() as well as suggested by Sunny and may be this as well:

=if(Id=$(v_Value), Description)

Re: An alternative for Fieldvalue

tresB — Tue, 08 Dec 2015 12:08:12 GMT

And if there are multiple Ids that can have the value, try like:

='The value : '&$(v_Value)& ' Id description(s) - ' & Concat( Distinct {<Id={'$(v_Value)'}>} Description , ',')

Re: An alternative for Fieldvalue

Tue, 08 Dec 2015 12:55:40 GMT

Working!!! Thank you so much!

Re: An alternative for Fieldvalue

Tue, 08 Dec 2015 12:56:13 GMT

Thank you so much for your help!

I used the only() and it works like a charm!

Re: An alternative for Fieldvalue

sunny_talwar — Tue, 08 Dec 2015 13:05:27 GMT

Great