Expression to count if a partial string exist in a field

[Neptune]

Hello All,

I imported an excel file into Qlik.

I have a column of data where I need to count if any the text contain the word 'blue'.

I wrote the expression:

If (MyColumn LIKE '*Blue*', count(MyColumn),)

The Gauge chart showing this results with no data. Any ideas why its not able to identify the rows using a partial string search?

Thanks

[Or · Accepted solution]

That formula is wrong on three levels:

* There's no "LIKE" statement in Qlik

* The if() should go inside the count(), not vice versa

* The syntax is incorrect because of the extra comma at the end

You could use:

Count(If(Wildmatch(MyColumn,'*Blue*'),MyColumn))

But a better approach would likely be to use Set Analysis:

Count({< MyColumn = {"*Blue*"} >} MyColumn)

[Neptune]

Thank you. Your tips solved my issue!