Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

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
jonathandienst
Partner - Champion III
Partner - Champion III

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
jonathandienst
Partner - Champion III
Partner - Champion III

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
Specialist II
Specialist II
Author

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