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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

match function in expression with variable list

I'm confused.  I have a variable called:

vDealerList with a definition of 333,334,335

IN an expressions, if [dealernumber] is equal to 333, this works, match([dealernumber],333,334,335) returning 1.

However, this will not, match([dealernumber],vDealerList), this returns 0

Am I missing somethign?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try a dollar sign expansion:

match([dealernumber],$(vDealerList) )

View solution in original post

1 Reply
swuehl
MVP
MVP

Try a dollar sign expansion:

match([dealernumber],$(vDealerList) )