topic Set analysis brackets elements '(Red)' in QlikView

Set analysis brackets elements '(Red)'

Thu, 07 Nov 2013 14:57:21 GMT

Hi, I am working on a set analysis and the elements of one field are in brackets like (Red).

I am trying to get:

=Sum( { $ <Colour = { '(Red)' }>} [Value] )

but it doesn't seem to be working.

Has anyone come across similar problem before?

Thanks,

Izabela

Clever_Anjos — Thu, 07 Nov 2013 15:01:47 GMT

=Sum( { $ <Colour = { '*(Red)' }>} [Value] )

should work

Thu, 07 Nov 2013 15:03:17 GMT

Thank you!

AlexOmetis — Wed, 29 Oct 2014 18:59:29 GMT

Thanks - that works... but why is this needed?

Clever_Anjos — Wed, 05 Nov 2014 15:11:05 GMT

maybe because '(' should be a special character into searches, * will workaround this