Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multi select "List Box" with default selection that can be removed when others value are selected..

I have created a List box in 'Windows checkbox' style with a multi selection possibilities and i have following Values:

- Value 1

- Value 2

- Value 3

- Value 4

- Value 5

- Total.

Now i want to have "Total" selected as default (When document loads and on Clear)

But when i select anny other value (incl. Multi select) the Total needs to be deselected.

Is this possible?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Not sure what you mean by 'when document loads'  so here are two methods:

1.  To default select total when document opens or when sheet is activated:

Right click on your sheet.

Select "Properties"

Navigate to "Triggers" tab

Add Action

Add

Action Type = Selection

Action = Select in Field

Type your listbox field in Field Box

Type Total in the Search String box

2.  To default select total when document reloads:

Settings - Document Properties - Triggers

In 'Document Event Triggers'

Select 'OnPostReload' and Add Action(s)

Add the selection per process above.

To default select total when you clear all:

Right click on your 'clear all' button.

Select Actions Tab

Add action

Add the same selection as the first two.

View solution in original post

3 Replies
Gysbert_Wassenaar

Select Total first. Then in the Selections menu click on the option Set Clear State. Finally save the document once. Now when you open the file Total will be selected until you select another value in the same field. If the click the Clear button then Total will be selected again.


talk is cheap, supply exceeds demand
Not applicable
Author

This will help me with the standard load. But it will not remove this selection as soon I selected another value.

Anonymous
Not applicable
Author

Not sure what you mean by 'when document loads'  so here are two methods:

1.  To default select total when document opens or when sheet is activated:

Right click on your sheet.

Select "Properties"

Navigate to "Triggers" tab

Add Action

Add

Action Type = Selection

Action = Select in Field

Type your listbox field in Field Box

Type Total in the Search String box

2.  To default select total when document reloads:

Settings - Document Properties - Triggers

In 'Document Event Triggers'

Select 'OnPostReload' and Add Action(s)

Add the selection per process above.

To default select total when you clear all:

Right click on your 'clear all' button.

Select Actions Tab

Add action

Add the same selection as the first two.