topic Re: Text Box product name display in QlikView

Text Box product name display

danialier — Thu, 23 Jan 2014 12:19:47 GMT

Hello,

I want a Text Box to show the names of the products selected. I succeed doing that when I select a product. However when I select two products, those are not displayed in the text box...

Attached QV for your reference

Please help.

thks,dani

Re: Text Box product name display

manideep78 — Thu, 23 Jan 2014 12:30:13 GMT

Hi,

Try this in your test object

='This is the product ' & GetFieldSelections(product,',',10)

go through GetFieldSelections() in help content.

Here 2nd parameter is a seperator. comma(,) in this case and 3rd parameter is max items that can display. 10 in this case. default is 6.

Hope this helps

Regards

Manideep

Re: Text Box product name display

sudeepkm — Thu, 23 Jan 2014 12:45:10 GMT

you can use concat function:

concat(product,' , ')

Please find the attached qvw.

Re: Text Box product name display

Thu, 23 Jan 2014 13:00:25 GMT

Hi Dani,

There are two ways of achieving it...

1. Create a variable and give the calcualtion for it like below and display the variable in a Textbox :

=GetFieldSelections(<Field Name>,'|')

2. Create a Variable.

Create a Button and create a Action 'Setvariable' and asign the below calculation to that variable and display in a textbox.

=GetFieldSelections(A)

Have attached a demo app.

Hope it helps !