Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

When I select the Single Data in the List box that should display in the textbox

Hi All,

Help me on this,When I select the Single Data in the List box the related particular field data that should display in the text box.

Ex:

   List Box                                Text Box

     3G                                      Related to 3G Data Should be

                                                  Displayed

Thanks & Regards,

Sivakumar

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

Concat([yourfield],'\n')

View solution in original post

8 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

=concat(distinct [particular field data],'; ')


talk is cheap, supply exceeds demand
Not applicable
Author

hi,

in text box expression use this

concat(DISTINCT [FieldName],';')

and

in layout->show-> Conditional give this condition

iGetSelectedCount(ListBoxField)=1

Regards

Vivek

Anonymous
Not applicable
Author

Hi Gysbert,

     Thanks for your reply i got it but i need vertical format.

EX :

           s001

           s002

           s003

Now iam getting in horizontal format.

 

EX : s001 s002  s003

Thanks & Regards,

Sivakumar

martinpohl
Partner - Master
Partner - Master

so edit to

=concat(distinct [particular field data],'; '&chr(10))

sudeepkm
Specialist III
Specialist III

Concat([yourfield],'\n')

tresesco
MVP
MVP

Use chr(13)  like:

=concat(distinct [particular field data] & chr(13) )

Anonymous
Not applicable
Author

Hi All,

Its possible to display two fields data  in one text object.

EX;

               text box it should like this.

              a       b

              1       tom

              2       raja

              3       rich

when i select data in list box

Thanks & Regards,

Sivakumar

sudeepkm
Specialist III
Specialist III

Concat(field1&'  '&field2,'\n')

EDIT: please try like below

='Field1'&'  '&'Field2'&'\n'&Concat(Field1&'  '&Field2,'\n')