topic Re: Listbox as checkbox in QlikView

Listbox as checkbox

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a list box on a sheet with Selection Style Override set to "Windows Checkboxes".

How would I set this checkbox as "checked" when the sheet is initially loaded?

Thanks

Re: Listbox as checkbox

Anil_Babu_Samineni — Mon, 13 Nov 2017 15:07:38 GMT

Try this way

Settings - General - Under "Selection Appearance" you can change..

Re: Listbox as checkbox

Anonymous — Mon, 13 Nov 2017 15:12:56 GMT

Is that under Settings -> Sheet Properties -> General? I don't see "Selection Appearance".

Re: Listbox as checkbox

Anonymous — Mon, 13 Nov 2017 15:15:46 GMT

Is it possible to do this programmatically (ie in macro)?

Re: Listbox as checkbox

Anil_Babu_Samineni — Mon, 13 Nov 2017 15:18:22 GMT

Can you help us your intend?

Re: Listbox as checkbox

Anonymous — Mon, 13 Nov 2017 15:20:35 GMT

Basically I have four checkboxes (list box) on the screen. When this screen is loaded or when the user clicks this tab/sheet, I want the first two checkboxes checked by default. This is what I want to accomplish.

Re: Listbox as checkbox

Anil_Babu_Samineni — Mon, 13 Nov 2017 15:39:44 GMT

I think you need OnActivateSheet() trigger using FieldName and Recipe for search string as

='(' & FieldValue | FieldValue2 & ')'

Re: Listbox as checkbox

Anonymous — Mon, 13 Nov 2017 15:59:25 GMT

Thanks for responding. I am still exploring various options and reading other posts in this forum. Here's the link and you actually commented on it last year.

List Box with default selection

There is a sample "2307770.qvw" from Clever Anjos. Where is the code that actually does the default selection?

In this case, "No Information" is the default. I looked at Settings -> Document Properties -> Triggers, I am not

seeing any code which handles this. Do you know where this code or logic is being stored in?

Re: Listbox as checkbox

Anil_Babu_Samineni — Mon, 13 Nov 2017 16:23:18 GMT

I believe it has been locked using Lock prompt and then Selection to each then once we clear it will be locked. And then to clear all you need to select option called "Unlock and Clear All"