Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
manodev47
Contributor
Contributor

How to do Vertical Concatenation of two fields to make one in Qlik Sense?

Hi,

     I am trying to concatenate  first_name with last_name in vertical direction.

so  i want to  display in following way

first_name                    last_name                         Full_mane

Qlik                               Sense                               Qlik

                                                                               Sense

Thanks

4 Replies
sunny_talwar

May be like this

first_name & Chr(10) & last_name as full_name

manodev47
Contributor
Contributor
Author

Thanks for quick response.

Actually Chr(10)/Chr(13) not working in a table as it works in Excel. Though I use these line break functions its concatenating horizontally. I used like following in scripting.


Script: first_name & Chr(10) & last_name as Full_name


first_name                    last_name                 Full_name        Expected Output

Qlik                               Sense                          QlikSense      Qlik

                                                                                                 Sense


chay                            veer                             chayveer           chay

                                                                                                  veer



I applied same formula in excel and did word wrap then I got the desired output in Excel. But when I  loaded same data source to qlik its again the output is horizontal concatenation. Is there any alternatives to show like desired output in table ?

Digvijay_Singh

Looks like it doesn't work in Qlik Sense. Even at Front end it doesn't split in next line. May be QS responsive architecture

doesn’t support it. Not sure if there is any alternative.

manodev47
Contributor
Contributor
Author

Thanks for your response. Even I did not find any alternatives. I agree with you that QS may not support this feature. Hope Qlik guys comes up with this functionality in future releases since Excel supports it.

Thanks guys...