topic Set analysis / trigger- hardcoding multiple selections in QlikView

Set analysis / trigger- hardcoding multiple selections

adamdavi3s — Tue, 17 Aug 2010 15:30:14 GMT

Hi All,

I am sure this is a really stupid question, but I have only been using Qlikview for three days!

I am using a sheet trigger to activate a listbox selection as I only want it to be active on this sheet.

I can get it working for one value:

trigger- Select In Field

Field- actlvl3_code

Search String ='1AGENCY'

But I can not for the life of me work out the syntax for multiple values!

I.e I want the search string to be (in SQL terms) = IN('1AGENCY','1BANK')

Set analysis / trigger- hardcoding multiple selections

Tue, 17 Aug 2010 15:44:23 GMT

You need to use ToggleSelect for any value after the first.

Select In Field - actlvl3_code - 1AGENCY
ToggleSelect - actlvl3_code - 1BANK

ToggleSelect will make another selection while keeping the current selection. If the value is already selected, it will unselect it.

Set analysis / trigger- hardcoding multiple selections

adamdavi3s — Tue, 17 Aug 2010 15:46:12 GMT

Fantastic thank you!

I think things will become a lot clearer once I have the developer course under my belt!

Set analysis / trigger- hardcoding multiple selections

Tue, 17 Aug 2010 15:57:55 GMT

Yeah, don't sweat it. The Triggers are a new feature, so they are still a little tricky. The Select/ToggleSelect requirement is the same as the macro API, so macro writers are used to doing it that way. It's all about repetition; after you create a few more, it will be second nature.