Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Match() Problem

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

4 Replies
Clever_Anjos
Employee
Employee

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

Clever_Anjos
Employee
Employee

Using your expression

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

Not applicable
Author

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!

Clever_Anjos
Employee
Employee

Very good, I´ve just commented below