Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Concat function

Hi Experts,

What is Concat function?  when will we use this? please share with example?

Regards,

Mahesh

12 Replies
Highlighted
Creator III
Creator III

Hi,

Hope this document will help you.

Highlighted
Specialist
Specialist

Hi Experts,

stalwar1kush141087swuehl

What is Concat function?  when will we use this? please share with example?

Regards,

Mahesh

Highlighted
Specialist
Specialist

Search 'concat' in Help option available in QlikView.

Everything is explained with examples.

You will at-least get an overview of it.

Highlighted
Creator II
Creator II

Highlighted
Specialist
Specialist

There are some good examples there.

CONCAT can be very useful for putting together a string of values as one expression which can be placed in a chart column. Even if the string is long and doesn't fit the column, the full value can be seen by hovering over it.

Highlighted

concat ( [ distinct ] expression [, delimiter [, sort-weight]] )

returns the aggregated string concatenation of all values of expression

iterated over a number of records as defined by a group by

clause. Each value may be separated by the string found in delimiter.

The order of concatenation may be determined by sort-weight.

Sort-weight should return a numeric value where the lowest value

will render the item to be sorted first. If the word distinct occurs

before the expression, all duplicates will be disregarded.

Example:

Load Department, concat(Name,';') as NameList

from abc.csv group by Department;

EG:

Department, Name

1,A

1,B

2,C

2,D


Results

Department,NameList

1, A;B

2, C;D

Highlighted
Master II
Master II

concat([{set_expression}]  [ distinct ] [ total [<fld {, fld}>]] expression[, delimiter[, sort_weight]])

Returns the aggregated string concatenation of all values of expression iterated over the chart dimension(s). Each value may be separated by the string found in delimiter. The order of concatenation may be determined by sort-weight. Sort-weight should return a numeric value where the lowest value will render the item to be sorted first.

Examples:

concat( Code, ';' )     

concat( FirstName&' '&LastName, ',' )    

concat( distinct Code, ';' )     

concat( total Name, ';' , Date )    

concat( total <Grp> Name, ';' , Date)

Highlighted
Contributor III
Contributor III

hi avinash ,

can u help me to get the name list2 column in following table:

dept  name  name list   name list2

1        a            a,b            c,d

1        b            a,b            c,d

2        c            c,d             a,b

2        d            c,d             a,b

i have got  result till name list. but i want column name list2 as shown in table.

what will be the logic..

pls help!

vegar.lie.arntsen

Highlighted
Partner
Partner

What are you trying to do in the name list2?  how would result name list2 look like for the following data set?

EG:

Department, Name

1,A

1,B

2,C

2,D

3,E

3,F

Plees ekskuse my Swenglish and or Norweglish spelling misstakes