topic Re: How to Pre-Select all Values in a Listbox? in QlikView

How to Pre-Select all Values in a Listbox?

Fri, 30 Jan 2015 10:51:32 GMT

Hello to All,

i want to ask you if is possible to preselect all items in a listbox when i open/reload the dashboard.

I need because i have to download automatically in excel some tables.

Thx a lot!

Re: How to Pre-Select all Values in a Listbox?

alexandros17 — Fri, 30 Jan 2015 10:54:17 GMT

Here it is my example

Re: How to Pre-Select all Values in a Listbox?

Fri, 30 Jan 2015 10:59:37 GMT

here... where?

Re: How to Pre-Select all Values in a Listbox?

alexandros17 — Fri, 30 Jan 2015 11:03:57 GMT

Click on the main title and scroll all the answers, there is an attachment

Re: How to Pre-Select all Values in a Listbox?

sunny_talwar — Fri, 30 Jan 2015 11:06:54 GMT

You can put a trigger both on open/reload by going into document properties and add actions for OnOpen and OnPostReload for your field name and do select possible.

Best,

Re: How to Pre-Select all Values in a Listbox?

alexandros17 — Fri, 30 Jan 2015 11:07:23 GMT

Use this otherways

Write in the script
AAA:
LOAD * Inline [
Values
Italy
France
UK
USA
Germany
];

Settings -> Document properties -> Triggers -> on open -> select in field

Write Values in the upper textbox and write
='(France|Italy)'
in the bottom textbox

Hope this helps

Re: How to Pre-Select all Values in a Listbox?

Anonymous — Fri, 30 Jan 2015 13:01:45 GMT

Yes this is possible. Find attached application clear selection and reload it %AircraftGroupID field will be selected.

Re: How to Pre-Select all Values in a Listbox?

Anonymous — Mon, 02 Feb 2015 05:04:57 GMT

Hi Alfonso Gaizo Have you tried above solution ? is your problem resolved ?

Re: How to Pre-Select all Values in a Listbox?

Fri, 06 Feb 2015 09:43:16 GMT

Yes,

thank you all