Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)
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