topic Wildmatch within set analysis. in QlikView

Wildmatch within set analysis.

Mon, 05 Oct 2015 11:58:19 GMT

The below set analysis is not working.I want to do the wildmatch for Tech and I see the error mark near the % sign ({'*Tech*'}>}%))

=num(avg({$<Name={'*Tech*'}>}%),'#,##0%')

Thank you very much.

tresB — Mon, 05 Oct 2015 12:01:58 GMT

num(avg({$<Name={'*Tech*'}>} FieldName or Expression),'#,##0%')

In place of fieldname/expression, you are putting % . What is this % ?

rubenmarin — Mon, 05 Oct 2015 12:41:17 GMT

Hi, I crated a sample data with 'Name' and '%' as fields and this expression works:

=num(avg({$<Name={'*ABS*'}>}%),'#,##0%')

So I don't know why it's not working for you... [%] is a field name?

Mon, 12 Oct 2015 18:53:31 GMT

Thank you.It worked for me .