topic Wildcard Character in Expression in QlikView

Wildcard Character in Expression

Wed, 05 Feb 2014 21:15:43 GMT

Are there any Wildcard characters that I can use when searching for a string in a subject line? In other words lets say I have 10 lines of strings and 5 out of those lines has the word "password" in the subject. I want to count the lines and return 5 as the result.

David

Re: Wildcard Character in Expression

Anonymous — Wed, 05 Feb 2014 21:20:39 GMT

Do you mean like this?

count ({<Subject={'*password*'}>} Subject)

Re: Wildcard Character in Expression

Wed, 05 Feb 2014 21:21:49 GMT

Hi,

You could try:

sum({<[YourFieldName= {'*password*'}>} YourFieldName)

Best,

Matt