Making text box show only the first selection in a field

[#1]

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:

A

B

C

D

E

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.

[vishsaggi · Accepted solution]

Try this in your two list boxes.

Textbox1:

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

Textbox2:

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

[#3]

Brilliant! Thanks for your help Vishwarath

[vishsaggi]

No problem.