Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
Sum ({$<%KlantNrNav = {"*$(vRelatie)*"}>}[Tot. uitk. doss.])
You can try to use wild search like
sum({$<Year={2000}, Region={“U*”}>} Sales)
for more information
Try like:
Sum ({$<%KlantNrNav = {"*$(vRelatie)*"}>}[Tot. uitk. doss.])
Thank you very much! I never realized the solution would be that basic!
Worked like a charm!