topic Re: How can we select a value from listbox and display it in text box? in QlikView

How can we select a value from listbox and display it in text box?

Wed, 12 Feb 2014 10:57:38 GMT

Hi all please help me out for the above question.
I have values in the listbox loaded whenever a user selects a particular value from listbox it need to be displayed in textbox field.

As I am new to Qlikview i couldn't make it out.please help me.Urgent.

Thanks in Advance
Sravani.k

Re: How can we select a value from listbox and display it in text box?

marcus_sommer — Wed, 12 Feb 2014 11:35:07 GMT

You could use getfieldselections(YOURFIELD, YOURDELIMITER).

- Marcus

Re: How can we select a value from listbox and display it in text box?

Thu, 13 Feb 2014 04:53:52 GMT

Thanks for the reply.

but the thing is whenever user clicks a button then the selected value need to be loaded in text box...

thanks in advance.

Re: How can we select a value from listbox and display it in text box?

Thu, 13 Feb 2014 05:07:50 GMT

=Concat(Fieldname, '#')

Re: How can we select a value from listbox and display it in text box?

sundarakumar — Thu, 13 Feb 2014 05:08:57 GMT

Hi,

create a text box and put this in text

=getfieldselection(field,delimiter)

-Sundar

Re: How can we select a value from listbox and display it in text box?

sunilkumarqv — Thu, 13 Feb 2014 05:13:26 GMT

Hi Sravani,

Try this copy and paste in your textobox change Listboxtable name

='Listbox Selection Name ' & If(GetSelectedCount(ListboxTableName)>0, GetFieldSelections(ListboxTableName))

Re: How can we select a value from listbox and display it in text box?

Thu, 13 Feb 2014 06:31:02 GMT

I Thank everyone for the reply.

but the thing is whenever user clicks a button then the selected value need to be loaded in text box...
Help me out for the Problem.

thanks in advance.

Re: How can we select a value from listbox and display it in text box?

hschultz — Thu, 13 Feb 2014 06:32:56 GMT

If the values from the button is pre defined you could use the QV button functionality, setting a variable to that value

Re: How can we select a value from listbox and display it in text box?

sundarakumar — Thu, 13 Feb 2014 06:34:14 GMT

Pls explain in detail.

What we have explined will show the seleted values in a seperate list box.

Pls specify what you need to achive in detail..

-Sundar

Re: How can we select a value from listbox and display it in text box?

MK_QSL — Thu, 13 Feb 2014 06:45:53 GMT

Check Enclosed File

Re: How can we select a value from listbox and display it in text box?

Thu, 13 Feb 2014 07:35:10 GMT

There r Some values in the list box when user selects one value and then if user Clicks the button i.e, after selecting a value in list box then that selected value need to be displayed in text box...

Re: How can we select a value from listbox and display it in text box?

MK_QSL — Thu, 13 Feb 2014 07:37:49 GMT

check my reply...

Re: How can we select a value from listbox and display it in text box?

Thu, 13 Feb 2014 09:53:12 GMT

ya that is correct but the value that is stored in variable vShow need to be displayed in textbox. so, plz help me how to do it instead of displaying it with getFieldSelections().

i have tried it in textbox with expn as =$(vShow) but output can't be displayed.

Thanks in advance.

Re: How can we select a value from listbox and display it in text box?

MK_QSL — Thu, 13 Feb 2014 09:58:38 GMT

Change Text Expressions as below..

='vSHOW = '& vSHOW & CHR(10)&'Selected Value from Customer List Box ' & CHR(10) & CHR(10)

& Concat(GetFieldSelections(Customer),', ')

Re: How can we select a value from listbox and display it in text box?

Fri, 14 Feb 2014 04:29:38 GMT

Thank You Manish.

Re: How can we select a value from listbox and display it in text box?

Sun, 16 Feb 2014 17:22:06 GMT

Hi Manish,

thanks for the response it is working...

but other requirement is that whenever we select a value in any of the list box and click the button the data need to be appeared in text box continuously.

i.e if i select a value from list box A and click the button the data need to be displayed in text box,

similarly if i select a value from list box B and click the button the data need to be displayed in text box

so how can i achieve this please help me.

Thanks in Advance,

sravani k.