Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

WildMatch

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

1 Solution

Accepted Solutions

Re: WildMatch

Try this:

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

View solution in original post

4 Replies

Re: WildMatch

Try this:

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

View solution in original post

Not applicable

Re: WildMatch

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

Not applicable

Re: WildMatch

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

No problem.

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

Best,

Sunny