topic Re: Match with dynamic values from field in QlikView

Match with dynamic values from field

pepe2209 — Thu, 13 Mar 2014 15:23:07 GMT

Hello

I was trying to create a match function where the values to match with are dynamic by a field. I thought of something like this but it's not working:

=match( 'D', concat(distinct(FIELD), ', '))

and FIELD is something like this

so if 'D' is present within FIELD it should give a number >0 (in this case 4). does anyone know if this is possible?

your help would be much appreciated

regard,

Peter

SunilChauhan — Thu, 13 Mar 2014 15:25:35 GMT

Try this

=match( concat(distinct(FIELD), ', '), 'D')

jerem1234 — Thu, 13 Mar 2014 15:31:03 GMT

You'll need to do something similar to this:

match('D', $(=concat(distinct chr(39) & FIELD & chr(39), ','))

Hope this helps!

Thu, 13 Mar 2014 15:34:48 GMT

try this:

max(Match(FIELD,'D'))>0

if this = 1 so 'D' is present within FIELD

Hope this helps

maxgro — Thu, 13 Mar 2014 15:36:29 GMT

define a variable

v =chr(39) & GetFieldSelections(FIELD, chr(39) & ',' & chr(39)) & chr(39)

expression should be

=match('D', $(v))

see attachment

pepe2209 — Thu, 13 Mar 2014 15:53:24 GMT

This is exactly what i need thanks!