Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
london1980
New Contributor

Conditional Text Format in Expression

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

M

1 Solution

Accepted Solutions
idogridish2
Contributor II

Re: Conditional Text Format in Expression

hi london1980

you can use

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


see the attached


cheers

4 Replies
luizmendes118
New Contributor III

Re: Conditional Text Format in Expression

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())

Capturar.PNG

Re: Conditional Text Format in Expression

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

thanks

regards

Marco

idogridish2
Contributor II

Re: Conditional Text Format in Expression

hi london1980

you can use

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


see the attached


cheers

london1980
New Contributor

Re: Conditional Text Format in Expression

thank you all, wildmatch did the trick

Community Browser