topic Re: Display every selected field value in different text boxes. in QlikView

Display every selected field value in different text boxes.

sabahat_quazi — Mon, 24 Apr 2017 07:44:32 GMT

Hi All,

Suppose I have a list Box with values- Red,Blue,Green,Black, White

Now my requirement is - if I select Red it should display in one text box, if I further select Black it should display in another textbox and so on.

Is there any way to achieve this?

Kindly Suggest.

Thanks and Regards,

Sabahat

Re: Display every selected field value in different text boxes.

awhitfield — Mon, 24 Apr 2017 09:57:13 GMT

What should happen if you select more than one color in the list box?

Andy

Re: Display every selected field value in different text boxes.

sabahat_quazi — Mon, 24 Apr 2017 10:07:28 GMT

If I select ,for example 3 colors then they should get displayed in 3 different text boxes as below :

(Maximum limit is - 5 textboxes)

Re: Display every selected field value in different text boxes.

rahulpawarb — Mon, 24 Apr 2017 10:13:39 GMT

Hello Sabahat,

Trust that you are doing well!

Please refer attached sample application.

Regards!

Rahul

Re: Display every selected field value in different text boxes.

sabahat_quazi — Mon, 24 Apr 2017 11:51:34 GMT

Thanks Rahul .

But instead of hard coding Colors in expression, can we make it dynamic..as there could be 10+ values for color

Also on multiple select It should display all the values(maximum upto 5 )

Re: Display every selected field value in different text boxes.

Anonymous — Mon, 24 Apr 2017 12:21:46 GMT

Hi,

Consider this app, dynamically.

Best regards,

Cosmina

Re: Display every selected field value in different text boxes.

Anonymous — Mon, 24 Apr 2017 12:22:51 GMT

*It has condition on Layout

Re: Display every selected field value in different text boxes.

sabahat_quazi — Mon, 24 Apr 2017 13:13:09 GMT

Thanks Cosmina,

your solution worked well with requirement.

Thanks a lot.

Re: Display every selected field value in different text boxes.

kdmarkee — Fri, 01 Sep 2017 14:28:45 GMT

Using your color.qvw, how would you code it if you needed to select more than 6 field values? I'm working on a project where I allow the user to select up to 12 values of a list box, but after 6 selections, you get results like "7 of 42", for example instead of all 7 field values chosen. Thanks.

Re: Display every selected field value in different text boxes.

kdmarkee — Fri, 01 Sep 2017 14:41:59 GMT

Found my answer...there is a max value parameter in the function, ie, =GetFieldSelections(FieldName, ', ', 12)