Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

Concatenation of two expression not Working in Qliksense

hey Guys,

I m trying to concatenate two expression like Status and Alert like below

Status &' '&Alert   ( in the measure but it is not working together)

is it some kind of bug?? or m i doing something wrong?/

please suggest..

Abhay

3 Replies
MVP
MVP

Re: Concatenation of two expression not Working in Qliksense

If either Status or Alert is null, then the expression will return null.

If either Status or Alert do not have a single unique value in the context in which its being calculated (eg in a table row), then the expression will return null.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Concatenation of two expression not Working in Qliksense

These are called 'naked' field references. Usually a field reference in a chart or table will be inside an aggregation expression (Max(), Sum(), ...). These are presumably strings, so you could use MaxString() or Concat().

If the problem is nulls, then you could use

=If(IsNull(Status), ''. Status) & If(IsNull(Alert), '', Alert)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
abhaysingh
Contributor III

Re: Concatenation of two expression not Working in Qliksense

thanks  jonathan.. its working now but by creating variable..

Could you please suggest now i have two fields Status and Alert in single column by using concatenation... Can i do like that suppose i want to give color coding to that column only to Alert. let Say

Output is like below

Enable - Good now i want only Good Text should be change by Green Color and Enable would remain same.

Pls suggest..

Thanks

Abhay

Community Browser