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

Concatenate

Dears,

I need to concatenate 3 fields separated by space in the scrip editor.

Example:

[COL1]

[COL2]

[COL3]

And I need to show something like:

[COL1] [COL2] - [COL3]

How can I do it?

Another thing.
Is it possible to concatenate this values

[COL1] [COL2] - [COL3]

And do not show the [COL1]?

Why?

It's because I need the value of COL1 just to separate an specific type in order to avoid multiple sum on the frequency calculus.

So, the best thing for me would be

Concatenate:

[COL1] [COL2] - [COL3]

And show only:

[COL2] - [COL3]

If COL2= Bruno and COL3= Lelli

Then the value showed would be

Bruno - Lelli

Thanks guys

2 Replies
erichshiino
Partner - Master
Partner - Master

On the script, you can write:

load [COL1]&[COL2]& '-' & [COL3] AS KEY,

[COL1] AS [COL1]

[COL2]& '-' & [COL3] AS NAME

FROM  ...

This way you can use [COL1] on the interface for selecions

Key for some operation (to link tables or some types of count)

and NAME as the value to be showed.

Hope it helps,

Erich

Not applicable
Author

Here is how to concatenate in your script :

LOAD

COL1 & ' ' & COL2 & ' - ' & COL3 AS IDFullName,

COL2 & ' - ' & COL3 AS FullName

FROM ...

"IDFullName" will contain the 3 fields. You'll use it for your frequencies.

"FullName" will contain the 2 fields you really need.

If you don't need to display the content of "IDFullName", use instead

autonumber(COL1 & ' ' & COL2 & ' - ' & COL3) AS IDFullNameWith

This will convert your string into a unique integer. This will speed up the operations by QlikView (it's easier for a program to compare integers instead of strings).