topic Update textbox with selected value description in QlikView

Update textbox with selected value description

Wed, 19 Nov 2014 23:12:17 GMT

Hello All,

I have a listbox containing codes. I want to update a textbox with a long description of the code selected. The long description is in one of my loaded tables. For example if the user selects code ABCD, I want to retrieve "This is my long description" from my table and display in the textbox. Can someone please help?

Thanks in advance.

Re: Update textbox with selected value description

Wed, 19 Nov 2014 23:27:13 GMT

Hi,

If I understand ... you have a table with Code and Description like this:

Code | Description

A | This is my description 1

B | This is my description 2

C | This is my description 3

D | This is my description 4

E | This is my description 5

and you have Codes values in a list box, well if you load codes values (of list box) in script editor and named with the same name field in table of descriptions you just need an expression like this (in your text object):

=Only(Code)

best regards.

Re: Update textbox with selected value description

Anonymous — Thu, 20 Nov 2014 00:29:37 GMT

Hey,

PFA..

Hope ths helps.

Regards,

Chinna

Re: Update textbox with selected value description

jagan — Thu, 20 Nov 2014 00:59:48 GMT

Hi,

Try like this

If you always select one value the

=Only(Description)

If you have multiple then use

=Concat(Distinct Description, ', ')

Hope this helps you.

Regards,

Jagan.

Re: Update textbox with selected value description

Thu, 20 Nov 2014 02:19:21 GMT

Hi,

Try to link description in new table & use it in testbox.

Rgds,

Dhanushka

Re: Update textbox with selected value description

Thu, 20 Nov 2014 15:23:18 GMT

Thanks all! Exactly what I needed