Select possible action

Tue, 25 Aug 2015 12:52:23 GMT

Hi everyone,

I would like to make a button with an action that selects all possible in a certain customize listbox.

The expresion of my listbox is:

=if(operator= 'AAA' OR operator = 'BBB',Left(taskcardno,9))

Now for certain range of data selections, this listbox shows all possible options that I can select. With a button and an action I want to select these possible fields within this listbox. However the action 'Select Possible' seems limited. I cannot get the desired results. Any suggestions?

I know macro like:

ActiveDocument.Fields("CertainField").SelectPossible

But it is a customized non existing field, in my case:

ActiveDocument.Fields("=if(operator= 'AAA' OR operator = 'BBB',Left(taskcardno,9))").SelectPossible

but this is not possible. Is it possible to select all possible of a certain listbox by just entering the objects ID or something?

Re: Select possible action

marcus_sommer — Tue, 25 Aug 2015 13:06:48 GMT

I think I would at first try to generate this field as a native field within the script. If operator and taskcardno are within the same table you could use:

...

if(Match(operator, 'AAA', 'BBB'),Left(taskcardno,9)) as taskcardno_Short

...

and if not you could create a mapping for this.

- Marcus

topic Re: Select possible action in QlikView

Select possible action

Re: Select possible action