Qlik Community

Qlik Sense App Development

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

manodev47
New 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

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

May be like this

first_name & Chr(10) & last_name as full_name

manodev47
New Contributor

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

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
Honored Contributor III

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

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
New Contributor

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

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

Community Browser