Wildmatch in Set Analysis, using a variable

[hansdevr]

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]

You can try to use wild search like

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

for more information

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

[tresesco · Accepted solution]

Try like:

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

[hansdevr]

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

Worked like a charm!