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

[Anonymous]

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

[sunny_talwar]

May be like this

first_name & Chr(10) & last_name as full_name

[Anonymous]

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.

[Anonymous]

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...