topic Re: Concat function in QlikView

Concat function

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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

Regards,

Mahesh

Re: Concat function

bindu_apte — Wed, 15 Jun 2016 10:44:52 GMT

Hi,

Hope this document will help you.

Re: Concat function

qlikview979 — Wed, 15 Jun 2016 10:54:29 GMT

Hi Experts,

stalwar1‌kush141087‌swuehl‌

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

Regards,

Mahesh

Re: Concat function

varshavig12 — Wed, 15 Jun 2016 11:17:24 GMT

Search 'concat' in Help option available in QlikView.

Everything is explained with examples.

You will at-least get an overview of it.

Re: Concat function

Anonymous — Wed, 15 Jun 2016 12:23:39 GMT

Check this out :

Examples of concat functions ‒ QlikView

Re: Concat function

richard_chilvers — Wed, 15 Jun 2016 12:44:17 GMT

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.

Re: Concat function

avinashelite — Wed, 15 Jun 2016 13:21:09 GMT

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

Re: Concat function

qlikviewwizard — Wed, 15 Jun 2016 14:47:25 GMT

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)

Re: Concat function

Anonymous — Thu, 08 Dec 2016 05:28:06 GMT

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

Re: Concat function

Vegar — Sat, 10 Dec 2016 19:37:14 GMT

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

Re: Concat function

Anonymous — Mon, 12 Dec 2016 04:25:46 GMT

In namelist2 column i want the column "name" values which are not matching with its id using concatenation..

so the result for your example should be as follows:

department Name Namelist2

1 A,B C,D,E,F

2 C,D A,B,E,F

3 E,F A,B,C,D

this result i am expecting.

Re: Concat function

Anonymous — Mon, 12 Dec 2016 05:00:10 GMT

Hi,

In Qlikview,

If you have two tables with same structure and with same number of fields along with same data qlikview automatically concatenate both the tables.

and

if you have to concatenate the tables in other scenarios (means...if you don't have tables with same structure) you can use the 'concatenation' statement to combined these both tables.

and

if you have to combined the two fields,you can use the & (concatenation symbol) in both the script and front end(like...in calculated expression or in calculated dimensions).

Re: Concat function

Mon, 12 Dec 2016 06:12:20 GMT

I think Concate is used to merge the record values and Concatenate is merge the fields