Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select possible action

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?

1 Reply
marcus_sommer

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