Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
first_name & Chr(10) & last_name as full_name
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 ?
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.
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...