Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concat (Emergency)

Please explain me where we use concat function. and how we use it in script part.

Example please

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Usha,

Please check the Reference Manual or the F1 help (both have the same contents) in order to get information on how a function works, and post when something is not clear and adding as much information as possible regarding your issue. Check this document post on how to use the Community and get the best results.

What Concat() does is to append field (or fields) values. Using the following piece of script.

Names:

LOAD * INLINE [

Name

Mike

John

Peter

Paul

];

After reloading, creating a new text object with the following expression

=Concat(Name, ',')

Will return the following string

Mike,John,Peter,Paul

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Concat is used to concatenate two field values.

    For example consider you have table where you have customer info like customer id, Name, Address1, Address2, City, District, State

    Now as you can see here in your table you have address spilt in to many fields, if you want to combine them into one, you can use the concat function to concat them one after another.

    Hope you understood.For more information you can look in to help.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Miguel_Angel_Baeyens

Hi Usha,

Please check the Reference Manual or the F1 help (both have the same contents) in order to get information on how a function works, and post when something is not clear and adding as much information as possible regarding your issue. Check this document post on how to use the Community and get the best results.

What Concat() does is to append field (or fields) values. Using the following piece of script.

Names:

LOAD * INLINE [

Name

Mike

John

Peter

Paul

];

After reloading, creating a new text object with the following expression

=Concat(Name, ',')

Will return the following string

Mike,John,Peter,Paul

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

SunilChauhan
Champion
Champion

pose i have to display Business ,Bookssize  in same expression for Example

then you will display like

Booksize,Business

then we can write like

=concat(Business,',',Bookssize)

Sunil Chauhan