topic Re: Concatenation / Set Analysis Help in QlikView

Concatenation / Set Analysis Help

Tue, 17 Jun 2014 17:22:46 GMT

Hello all,

I am trying to concatenate several values together based on a different value which I assume requires the use of set analysis and I can't get the syntax correct. Example:

"Field 1" & " " & "Field 2" where Field 3 = "USA"

In this case, Field 3 = "USA" will only return 1 value and I'm trying to place this expression in a text object as a label.

Thanks in advance.

Re: Concatenation / Set Analysis Help

venkatg6759 — Tue, 17 Jun 2014 17:28:45 GMT

Concat(Distinct{$<Field3={'USA'}>}Field 1& ' '& Field 2)

Re: Concatenation / Set Analysis Help

maxgro — Tue, 17 Jun 2014 17:47:36 GMT

when there is space in field name, use "field name" or [field name]

for field value USA, without spaces, you can use USA or 'USA' or "USA"

concat(Distinct{$<[Field 3] ={USA}>} [Field 1] & ' ' & [Field 2] )