topic Re: Making text box show only the first selection in a field in QlikView

Making text box show only the first selection in a field

Thu, 09 Feb 2017 16:09:08 GMT

Hi,

I'm using QlikView and am trying to get a few text boxes that will each show one selection from a field.

For example, if the field is:

Letters:

If I select B and D, I would like a text box that somehow looks at all the current selections in the field Letters but only displays the first one. Additionally I would like another text box that only displays the second selection.

I've tried a text box with '=getfieldselections(Letters)' but this prints all of the selections.

Is there a way to do this?

Thanks very much for any help.

Re: Making text box show only the first selection in a field

vishsaggi — Thu, 09 Feb 2017 16:29:13 GMT

Try this in your two list boxes.

Textbox1:

=Subfield(GetFieldSelections( Letters), ',',1)

Textbox2:

=Subfield(GetFieldSelections( Letters), ',',2)

Re: Making text box show only the first selection in a field

Thu, 09 Feb 2017 16:35:02 GMT

Brilliant! Thanks for your help Vishwarath

Re: Making text box show only the first selection in a field

vishsaggi — Thu, 09 Feb 2017 16:40:16 GMT

No problem.