topic Re: Match() Problem in QlikView

Match() Problem

Mon, 25 Nov 2013 18:13:02 GMT

Hello,

I am using a variable referencing field selections to populate a Match function.

=Match('Count',$(vStoreListMetrics))

vStoreListMetrics is set to =chr(39) & getfieldselections(MetricNames, chr(39) & ',' & chr(39) ) & chr(39)

When I have selected Count from the MetricNames field, I can confirm that vStoreListMetrics evaluates to 'Count'. However the Match function is still returning 0.

Does anyone know why the Match function isn't recognizing the string and the variable evaluation as matching?

Thanks for any help!

Autumn

Re: Match() Problem

Clever_Anjos — Mon, 25 Nov 2013 18:40:15 GMT

=match( 'Count',$(=chr(39) & getfieldselections(MetricNames, chr(39) & ',' & chr(39) ) & chr(39)))

Re: Match() Problem

Clever_Anjos — Mon, 25 Nov 2013 19:02:08 GMT

Using your expression

=Match('Count',$(=vStoreListMetrics))

Re: Match() Problem

Mon, 25 Nov 2013 19:02:17 GMT

I tried this and it worked, and helped me realize I just had to wrap the variable in another dollar sign expansion like you did above... $(=$(vStoreListMetrics))

Thank you!

Re: Match() Problem

Clever_Anjos — Mon, 25 Nov 2013 19:03:15 GMT

Very good, I´ve just commented below