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

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

Thu, 30 May 2013 14:07:19 GMT

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?

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

Gysbert_Wassenaar — Thu, 30 May 2013 14:18:41 GMT

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.

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

Thu, 30 May 2013 14:26:27 GMT

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

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

Anonymous — Mon, 22 Jul 2013 21:00:54 GMT

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.