Exclude specific text in the value in Set analysis

[btaccent]

Hi,

I have below values i want to exclude 'High' related values using set analysis. WE use Qliksense

Field
Energy - High - 18/3/2023
Energy - Low - 18/3/2023

I have tried using below expression, but it is not working.

count({<Field -={'*High*'}>} sales)

Please help.

[Or]

count({<Field -={'High'}>} sales)

[btaccent]

'High' is a single word in the value(as you can see in the example above). So not sure if it works.

[btaccent · Accepted solution]

I found the solution. We need to use DOUBLE QUOTES around the value in set analysis.

count({<Field -={"*High*"}>} sales)

[Or]

Ah. That wasn't quite clear to me, sorry.

count({<Field -={"*High*"}>} sales)

Double quotes are necessary to treat the string as a search string rather than a direct match.