topic Re: trigger search string to select <>'Invalid Region Code!' in QlikView

trigger search string to select <>'Invalid Region Code!'

stevelord — Tue, 07 Jul 2015 15:25:16 GMT

Hi, I've tried a variety of approaches to get a trigger to select everything in an OfficeCode field except 'Invalid Region Code' short of listing all of the OfficeCodes out.

The trigger is on the Sheet -> OnActivate and I set it as SelectInField, FieldName=OfficeCode, AlternateState = <default state>

Just stuck on the search string to select all but the one value. I tried using:

not

with a:

wildmatch(OfficeCode, 'Invalid*')

'Invalid Region Code!'

...wonder if select possible, followed by select invalid region code will do it actually..

..just tested that. It was Select Possible in field OfficeCode followed by a trigger for Toggle Select in field OfficeCode searh string ='Invalid Region Code!'

..so... pretend this was an awesomely short 'howto' blog.. marking assumed answered.

Re: trigger search string to select <>'Invalid Region Code!'

m_woolf — Tue, 07 Jul 2015 15:29:48 GMT

Use 2 actions:

First Select 'Invalid Region Code!

Then

SelectExcluded

Re: trigger search string to select <>'Invalid Region Code!'

stevelord — Tue, 07 Jul 2015 15:38:06 GMT

Good flip on the select possible / toggle selection approach I came on while talking to myself. Thanks!

(This is one of the ones where I tap my forehead and go 'duh'. )