Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

=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')