topic Re: Concat and text formatting or coloring in QlikView https://community.qlik.com/t5/QlikView/Concat-and-text-formatting-or-coloring/m-p/1420258#M428569 <HTML><HEAD></HEAD><BODY><P>No - there are no formatting within strings as such. Not with Concat() nor with other type of text manipulations.</P></BODY></HTML> Sun, 19 Nov 2017 20:27:26 GMT petter 2017-11-19T20:27:26Z Concat and text formatting or coloring https://community.qlik.com/t5/QlikView/Concat-and-text-formatting-or-coloring/m-p/1420257#M428568 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Is it possible to apply some text formatting like bold, italic or color code when concat is being used to build the string?</P><P>Thanks</P><P>Jean</P></BODY></HTML> Sun, 19 Nov 2017 20:00:53 GMT https://community.qlik.com/t5/QlikView/Concat-and-text-formatting-or-coloring/m-p/1420257#M428568 jduluc12 2017-11-19T20:00:53Z Re: Concat and text formatting or coloring https://community.qlik.com/t5/QlikView/Concat-and-text-formatting-or-coloring/m-p/1420258#M428569 <HTML><HEAD></HEAD><BODY><P>No - there are no formatting within strings as such. Not with Concat() nor with other type of text manipulations.</P></BODY></HTML> Sun, 19 Nov 2017 20:27:26 GMT https://community.qlik.com/t5/QlikView/Concat-and-text-formatting-or-coloring/m-p/1420258#M428569 petter 2017-11-19T20:27:26Z Re: Concat and text formatting or coloring https://community.qlik.com/t5/QlikView/Concat-and-text-formatting-or-coloring/m-p/1420259#M428570 <HTML><HEAD></HEAD><BODY><P>We doesn't have sub-string concept with color in Qlikview. May be they will work for that. Try a luck using below?</P><P></P><P><STRONG>If(SubStringCount(Concat(FieldName, '-'), 'YourString'), '&lt;B&gt; &lt;I&gt;')</STRONG></P><P><STRONG>If(SubStringCount(Concat(FieldName, '-'), 'YourString'), Green())</STRONG></P><P>OR</P><P><STRONG>If(SubField(Concat(FieldName, '-'), '-', 2), '&lt;B&gt;')</STRONG></P></BODY></HTML> Mon, 20 Nov 2017 03:16:46 GMT https://community.qlik.com/t5/QlikView/Concat-and-text-formatting-or-coloring/m-p/1420259#M428570 Anil_Babu_Samineni 2017-11-20T03:16:46Z