topic Re: WildMatch in QlikView

WildMatch

Thu, 21 Jan 2016 13:40:04 GMT

Hi Community

Wondering if anyone can help, I am using an expression = if(WildMatch(Function,'Group'),1,0) in a variable that I am using to show/hide another object.

"Function" is the value that is currently being used in a listbox, problem is that when I make other selections, e.g. 'Group' + 'Other', the resulting expression will be evaluated ad 0, as opposed to 1 if I select 'Group' alone!

Is there a way of saying, if Group IS FOUND IN or CONTAINS, then 1,0?

Thanks Community

Peter

Re: WildMatch

sunny_talwar — Thu, 21 Jan 2016 18:19:15 GMT

Try this:

=If(SubStringCount(Concat(DISTINCT Function, '|'), 'Group') = 1, 1, 0)

Re: WildMatch

Thu, 21 Jan 2016 18:31:25 GMT

Wildmatch or Match only works in only one value in the field, So you can use substringcount or Only functions to get desired result.

Re: WildMatch

Fri, 22 Jan 2016 09:35:09 GMT

Thanks Sunny

I joined the two equations together, this worked well. Thanks for the tip though, will be very usefull for future projects.

if(WildMatch(GetCurrentSelections(Function),'*Group*'),1,0)

Thanks again Sunny

Peter

Re: WildMatch

sunny_talwar — Fri, 22 Jan 2016 11:11:41 GMT

No problem.

If you got what you were looking for, please close the thread down by selecting correct and helpful answers.

Best,

Sunny