topic How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously? in QlikView

How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Sun, 16 Feb 2014 17:33:39 GMT

Hi,

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 URGENT.

Thanks in Advance,

sravani k.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

MK_QSL — Sun, 16 Feb 2014 17:36:12 GMT

=getcurrentselections ( chr(13)&chr(10) , ' : ' , ' ; ' )

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

maxgro — Sun, 16 Feb 2014 17:39:02 GMT

=GetFieldSelections(yourfield)

if you want a specific field

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

rbecher — Sun, 16 Feb 2014 20:34:20 GMT

Hi,

you can use a button action (external/set variable) and set the selected value to a variable which get shown continously in the text box. Perhaps you will log the selections a user made? If so please find attached example.

- Ralf

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 06:09:18 GMT

Hi Manish,

Thank you for the answer but what i need is only the values need to be displayed not the fieldnames along with the values in the textbox.

i.e if we select a value 'A' from Customer list box and Click the Button then only 'A' need to be displayed in text box not as Customer:A and if possible the value need to be deselected from listbox once displayed in text box.

Thanks
sravani k.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 06:09:59 GMT

Hi Ralf,

Thank you for the answer but what i need is only the values need to be displayed not the fieldnames along with the values in the textbox.

Thanks
sravani k.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

sunilkumarqv — Mon, 17 Feb 2014 06:16:22 GMT

Hi sravani,

as of manish exp edit like this. hope these is you looking for.

=' '& CHR(10) & CHR(10)

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

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 06:24:11 GMT

ya but it can't be only the customer listbox..

we can have many listboxes and when we select a value from particular list box and click the button then only the value selected need to be displayed in text box not the fieldname also...

thanks in advance

sravani.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

sunilkumarqv — Mon, 17 Feb 2014 06:35:41 GMT

For many list boxs you want list out whatever listboxnames and fields follow below script =' ' & If(GetSelectedCount(Listboxtablename1)>0, GetFieldSelections(Listboxtablename1)) &' ' &
If(GetSelectedCount(Listboxtablename2)>0, GetFieldSelections(Listboxtablename2)) &' ' &
If(GetSelectedCount(Listboxtablename3)>0, GetFieldSelections(Listboxtablename3)) &' ' &
If(GetSelectedCount(Listboxtablename4)>0, GetFieldSelections(Listboxtablename4)) &' ' &

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 07:03:01 GMT

Hi,

Try below:

=If(GetSelectedCount(FieldName1)>0, GetFieldSelections(FieldName1) & Chr(10) &

If(GetSelectedCount(FieldName2)>0, GetFieldSelections(FieldName2) & Chr(10) &

and son on..

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 07:27:48 GMT

ya,but what i need is after selecting when the button is clicked then data need to be displayed in text box not just after selecting from list box.

thanks

sravani.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

MK_QSL — Mon, 17 Feb 2014 07:30:19 GMT

In your last post, I have already shown the same by creating a variable and using a button to do so.

You can use the same here also.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 07:35:39 GMT

yes but when we are using variable to display then only that list box value can be displayed but not other listvalues.

what i need excatly is say we have 10 number of listboxes and we need to display data on textbox once a value is selected and button is clicked.

Thanks

sravani.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 07:38:20 GMT

yes but when we are using variable to display then only that list box value can be displayed but not other list box values.

what i need excatly is say we have 10 number of listboxes and we need to display data on textbox once a value is selected and button is clicked.

Thanks

sravani.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 07:40:25 GMT

Do you mean it like below?

I used a text text object

=Concat(DISTINCT Location, ',') for the DISTINCT Values

=Concat(Location, ',') for ALL the Values

Regards,

Sajeevan

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

MK_QSL — Mon, 17 Feb 2014 07:46:40 GMT

Please check enclosed file.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 08:34:22 GMT

ya if we select a value 'A' from customer list box and then click button say Hide text box then it need to be displayed in Selected Value from Customer List Box text box, and then if we select a another value from say country list box say France then click button say Hide text box then it need to be displayed in Selected Value from Customer List Box text box retaining the old one i.e,'A'. lly we need do for any no. of values.

thanks
Sravani.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 08:43:19 GMT

Why can't you use the current selections object?

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

sunilkumarqv — Mon, 17 Feb 2014 09:06:41 GMT

For that hide text box use variables as of manish post says.

Re: How can we Display values after selecting it from list box and then clicking a button and display it in text box continuously?

Mon, 17 Feb 2014 10:07:27 GMT

Hi Manish,

Thank you your Answer Worked. Thank you for your time and effort.

Sravani.