Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hansdevr
Creator III
Creator III

Wildmatch in Set Analysis, using a variable

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

Labels (2)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

View solution in original post

3 Replies
miskinmaz
Creator III
Creator III

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

Try like:

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

hansdevr
Creator III
Creator III
Author

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

Worked like a charm!