Showing '-' values as something else

[CJR]

Hi all,

Hoping someone can help with this - I'm sure it's basic but I've not figured it out!

I have a dimension to return a Yes or No dependent on the value in Field1 =if(match( [Field1],'A','B','C'),'Yes','No').

This works to return A, B and C as a Yes, and any other values in Field1 as a No. However, I want to also include anything with a blank value in Field1 as a 'No' but it's currently returning a '-' in my Qlik Sense visualisation.

I'm hoping someone can help out with this...I've tried using things like isnull and searching for blanks but. It feels like it should be easy to sort but I'm failing! 🙂 Thanks!

[vinieme12]

use Pick() and Wildmatch() instead as below

Match() is case sensitive

=Pick(Wildmatch( [Field1],'A','B','C')+1,'Yes','No')

[CJR]

Hi Vineeth, thanks for the reply, but having tried what you've suggested it doesn't appear to have worked. I'm still having the issue of returning 'yes'. 'no' and '-' but I need the '-' to be displayed as 'no'...

Any suggestions as to what I'm doing wrong please?!

[vinieme12]

try with wildmatch()

=if(Wildmatch( [Field1],'A','B','C'),'Yes','No')

[MayilVahanan]

Hi

Try like below

Coalesce( if(match( [Field1],'A','B','C'),'Yes'), 'No')

[CJR]

Thanks for the other messages - unfortunately the options suggested are still leading to the same result. I'll keep trying other things!

[SchalkF]

Hi,

Is it possible that your data set includes Null values in Field1?

If there is maybe try (If(Not IsNull(Field1), (Wildmatch( [Field1],'A','B','C'),'Yes','No'), 'No')

Kind regards