Combining two expressions

[hammermill21]

Hello,

I have KPI's that show me reason items are failed with the expression:

upper(left(trim(Reason),1)) & lower(mid(trim(Reason),2,len(Reason)))

which works perfectly, but I also need to add if one of the reasons is inspection_tag to be replaced with Inspection Tag (no underscore), so I wrote this expression:

If([Reason]='Inspection_tag',Replace([Reason],'Inspection_tag','Inspection Tag')))

Each expression works fine alone but when I put them together I get an error. Can someone help me with this?

Thank you!

[sunny_talwar · Accepted solution]

May be this

If([Reason]='Inspection_tag', 'Inspection Tag', upper(left(trim(Reason),1)) & lower(mid(trim(Reason),2,len(Reason))))

[hammermill21]

I see now what I did wrong Sunny! Thank you so much, you are fantastic!

[Shubham_D]

Hi Sunny,

Conditional coloring is not working in case of such COncat (&) in QLikSense.

Any idea how to make it  ? 

Rgds,

Shubham