topic Re: Using Selections on Multiple Fields to Show/Hide Object in QlikView

Using Selections on Multiple Fields to Show/Hide Object

makximenkoa — Sun, 12 Nov 2017 23:02:20 GMT

Hello,

I am attempting to use wildmatch and the getcurrentselections functions together to conditionally show/hide an object. The goal would be that if a selection was made on any field other than the ones below, an object is shown

Here is the equation I am attempting to use for the conditional show/hide (from the discussion here):

=if(Wildmatch(GetCurrentSelections(), $(=concat({< [$Field] =-{'[Discharge Department]','[MonthAbvYear]','[Attending Provider]', '[Location]'}>} chr(39) & '*' & [$Field] & '*' & chr(39),',')) )>=1,1,0)

The goal would be that if a selection was made on any field other than the ones above, an object is shown. It works fine for the Attending Provider and Location fields but for some reason does not work on the Discharge Department or MonthAbvYear fields. There are no differences between the 4 fields that I can tell that would cause them to behave differently. When I input just the '=concat(...)' function into a text object, the concatenated text looks correct. Maybe there's something going on with the wildmatch component?

Any help would be greatly appreciated!

Message was edited by: Al Makximenko

Re: Using Selections on Multiple Fields to Show/Hide Object

sunny_talwar — Sun, 12 Nov 2017 23:36:06 GMT

Do you really need the square brackets around your fields? Have you tried this?

=WildMatch(GetCurrentSelections(), $(=Concat({<[$Field] =-{'Discharge Department', 'MonthAbvYear', 'Attending Provider', 'Location'}>} Chr(39) & '*' & [$Field] & '*' & Chr(39), ',')))

or this

=If(WildMatch(GetCurrentSelections(), $(=Concat({<[$Field] =-{'Discharge Department', 'MonthAbvYear', 'Attending Provider', 'Location'}>} Chr(39) & '*' & [$Field] & '*' & Chr(39), ',')))>=1, 1, 0)

Re: Using Selections on Multiple Fields to Show/Hide Object

makximenkoa — Mon, 13 Nov 2017 00:57:39 GMT

Thank you for the reply. Yes, I've tried with the brackets and without but unfortunately I get the same results either way.

Re: Using Selections on Multiple Fields to Show/Hide Object

sunny_talwar — Mon, 13 Nov 2017 12:29:33 GMT

How about this

=WildMatch(GetCurrentSelections('|', ': ', ',', 500000), $(=Concat({<[$Field] =-{'Discharge Department', 'MonthAbvYear', 'Attending Provider', 'Location'}>} Chr(39) & '*' & [$Field] & '*' & Chr(39), ',')))

or this

=If(WildMatch(GetCurrentSelections('|', ': ', ',', 500000), $(=Concat({<[$Field] =-{'Discharge Department', 'MonthAbvYear', 'Attending Provider', 'Location'}>} Chr(39) & '*' & [$Field] & '*' & Chr(39), ',')))>=1, 1, 0)

Re: Using Selections on Multiple Fields to Show/Hide Object

makximenkoa — Mon, 13 Nov 2017 13:04:51 GMT

I tried the above and am still getting the same results.

Re: Using Selections on Multiple Fields to Show/Hide Object

sunny_talwar — Mon, 13 Nov 2017 13:06:48 GMT

Would it be possible to share a sample where you can replicate your issue?

Re: Using Selections on Multiple Fields to Show/Hide Object

makximenkoa — Tue, 14 Nov 2017 16:13:27 GMT

I've attached a sample above.

Re: Using Selections on Multiple Fields to Show/Hide Object

sunny_talwar — Tue, 14 Nov 2017 17:41:12 GMT

Try this

=if(Wildmatch('|' & GetCurrentSelections(', |', '|:'), $(=concat({< $Field -= {'Attending Provider','Location','Discharge Department','MonthAbvYear'}>} chr(39) & '*|' & $Field & '|*' & chr(39) ,',')))>=1,1,0)

Re: Using Selections on Multiple Fields to Show/Hide Object

makximenkoa — Tue, 14 Nov 2017 20:13:29 GMT

Works like a charm, thank you!