topic Re: Expression to consider just a string in QlikView

Expression to consider just a string

Mon, 16 Nov 2015 15:56:16 GMT

Hi,

I have a table and a field that has a field similar to the one shown below

Data

Yes - ABCD

Yes - XYZ

Yes - QWER

No - ABCD

No - XYZ

I need to get an expression where if the filed values has 'Yes' in it regardless of what's attached to it, the color of the field should be Green, or it must be Red otherwise. Any help how to frame the expression? The expression should only see if the field value has Yes or No regardless of the following data.

Re: Expression to consider just a string

sunny_talwar — Mon, 16 Nov 2015 16:01:58 GMT

May be this in background color expression:

If(WildMatch(Data, 'Yes*'), Green(), Red())

Re: Expression to consider just a string

swuehl — Mon, 16 Nov 2015 16:02:46 GMT

Something like

IF(Data LIKE 'Yes*', Lightgreen(), Lightred() )

Re: Expression to consider just a string

Mon, 16 Nov 2015 16:12:27 GMT

Let me try both the expressions and come back with the results. Thanks a lot guys.

Re: Expression to consider just a string

Mon, 16 Nov 2015 16:13:54 GMT

Thank you so much both of you. It worked.

Re: Expression to consider just a string

satishkurra — Mon, 16 Nov 2015 16:20:48 GMT

If(Data='Yes',Green(),Red())

Or you can even try the below expression for better performance.

=if(complex expression, dual(‘Y’,green()), dual(‘N’,red()))

Re: Expression to consider just a string

sunny_talwar — Mon, 16 Nov 2015 16:37:45 GMT

Great, if you got what you were looking for, please close the thread