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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
4 Replies
Clever_Anjos
Support
Support

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

Clever_Anjos
Support
Support

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
Support
Support

Very good, I´ve just commented below