Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kasdalinassim
Contributor

Key Concatenation best use

Hi all,

I'm looking for your advice in the aim the get a optimized script.

sometimes, i've to do a concatenation of different keys, it can takes 9 keys by the way.

in this way, what function you advice me to use Autonumber() ? autohash128() ? autohash256() ?

and what about concat()

regards

1 Reply
Not applicable

Re: Key Concatenation best use

Hello Nassim,

Could you see this post which talk about Autonumber and AutonumberHash :

http://community.qlik.com/message/289359#289359

You can use Concat() in order to get all the possible values in a field. For example, you can have a field TEST which contains this values :

- A

- B

- C

- D

If you do this :

concat(TEST, ';')

The result will be :

A;B;C;D

You can read the Help (F1) in order to have more explanations.

Amand Dupretz

Community Browser