topic Wildmatch in Set Analysis, using a variable in QlikView

Wildmatch in Set Analysis, using a variable

hansdevr — Sat, 16 Nov 2024 02:50:04 GMT

Hi dear QlikViewers,

I'm using this Set Analysis function:

Sum ({$<%KlantNrNav = {'$(vRelatie)'}>}[Tot. uitk. doss.])

I am getting the variable vRelatie from an input box. Now, how do I get this function to seek a partial vRelatie?

For instance, if someone inputs 05694 in stead of A-05694, how can I get the function to list all customers matching this partial number?

Any help would be very welcome!

Regards,

Hans

miskinmaz — Fri, 02 Aug 2019 09:40:45 GMT

You can try to use wild search like

sum({$<Year={2000}, Region={“U*”}>} Sales)

for more information

tresB — Fri, 02 Aug 2019 09:50:35 GMT

Try like:

Sum ({$<%KlantNrNav = {"*$(vRelatie)*"}>}[Tot. uitk. doss.])

hansdevr — Fri, 02 Aug 2019 10:30:35 GMT

Thank you very much! I never realized the solution would be that basic!

Worked like a charm!