topic Re: Conditional Text Format in Expression in QlikView

Conditional Text Format in Expression

london1980 — Fri, 27 May 2016 13:08:31 GMT

Hi All,

I was wondering if it's possible to add conditional text formatting in and Expression.

Basically I want to make the text colour red if the cell contains one of these two "X:0A" or "D:01".

Thanks

luizmendes118 — Fri, 27 May 2016 17:32:32 GMT

You can click on that plus and use at the text color an if to insert the conditions, like if(Field='X:0A' or Field='D:01',red(),black())

MarcoWedel — Tue, 31 May 2016 23:07:02 GMT

please post a sample qvw that you want to test this function with.

thanks

regards

Marco

idogridish2 — Thu, 02 Jun 2016 21:28:11 GMT

you can use

if(WildMatch(Field,'*X:0A*','*D:01*'),LightRed(),LightGreen())

see the attached

cheers

london1980 — Fri, 03 Jun 2016 08:17:59 GMT

thank you all, wildmatch did the trick