topic Concatenate in QlikView

Concatenate

Wed, 11 May 2011 12:57:23 GMT

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

Concatenate

erichshiino — Wed, 11 May 2011 13:05:25 GMT

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

Concatenate

Wed, 11 May 2011 13:11:17 GMT

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