Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Making text box show only the first selection in a field

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.

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Try this in your two list boxes.

Textbox1:

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

Textbox2:

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

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

Try this in your two list boxes.

Textbox1:

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

Textbox2:

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

Not applicable
Author

Brilliant! Thanks for your help Vishwarath

vishsaggi
Champion III
Champion III

No problem.