Concatenate

[#1]

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

[erichshiino]

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

[#3]

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).