topic Listbox as Check box in QlikView

Listbox as Check box

carolin01 — Thu, 13 Mar 2014 10:06:26 GMT

Hello,

If I have a list box and use it as check box is it possible to keep a specific value always checked even if one press clear?

I would like to keep "Total" in my list box even if you click clear.

Many thanks in advance for your help.

Best regards,

Carolin

Re: Listbox as Check box

jsingh71 — Thu, 13 Mar 2014 10:09:57 GMT

Go to list box properties and select 'Always one vale select ' check box.

Re: Listbox as Check box

jsingh71 — Thu, 13 Mar 2014 10:11:10 GMT

Find screenshot for more clarification.

Re: Listbox as Check box

Thu, 13 Mar 2014 10:11:33 GMT

Hi Carolin,

You can use following Action/Triggers to achieve this:

Action Type: Selection

Action : Select In field

then give the field name and value you want to get selected.

Once done, add another Action as :

Action Type: Selection

Action : Lock Field

and add the name of the field in which you wnat the selections not to be cleared.

You can use these Actions/Triggers on any event per your requirements.

Hope this helps!

Re: Listbox as Check box

MK_QSL — Thu, 13 Mar 2014 10:12:06 GMT

Open the Link from enclosed file.
This is what you want..

Re: Listbox as Check box

senpradip007 — Thu, 13 Mar 2014 10:14:02 GMT

Hi jsingh71.

If I choose Always one value select you cant select all data of the list box.

I think you should go for trigger.

Re: Listbox as Check box

carolin01 — Thu, 13 Mar 2014 10:33:37 GMT

Unfortuntely this doesn´t work as it is not highlighted. You cannot choose this maybe because its a LED check box.

Re: Listbox as Check box

Thu, 13 Mar 2014 10:37:01 GMT

Hi Carolin,

It will be highlighted only when first you have selected a value.

Re: Listbox as Check box

PradeepReddy — Thu, 13 Mar 2014 10:37:35 GMT

Hi Shyamal,

I think it will lock the field value and won't allows any other selections in the same field.

Thansk, Pradeep

Re: Listbox as Check box

Thu, 13 Mar 2014 10:53:55 GMT

Hi Pradeep,
Yes, you are right. My bad 😞

Carolin Borchert : You can just give "Select In field" action on various events and skip "Lock field".

Re: Listbox as Check box

jsingh71 — Thu, 13 Mar 2014 10:59:59 GMT

Hi Carolin,

First you select Total from your list box and then click on Set Clear state option.

After that you can select other options also in list box and then click on clear. It will clear all other except the first one which you selected before click on Set Clear Set.

And also in Sheet properties add one trigger Select in Field for selecting specific option what you want.

Re: Listbox as Check box

Thu, 13 Mar 2014 11:04:44 GMT

Hope attached example is what you are looking for...

I have used a Field Event Trigger (Settings > Document Properties > Triggers) to toggle select 'Total' if 'Total' is deselected.

When you implement it for the first time, however, 'Total' might be unselected. But selecting it once will keep the Toggle Select cycle going forever.

Re: Listbox as Check box

jsingh71 — Thu, 13 Mar 2014 11:10:30 GMT

you are right pradip earlier I didn't checked, I thought carolin is using LED but she didn't.

Re: Listbox as Check box

carolin01 — Thu, 13 Mar 2014 11:28:17 GMT

I liked this but for some reason it didn´t work when I copied the expression from that weg page. I noticed that I had to use [$Field] instead which worked first well but it stopped working at this stage:

As you can see from the text box it doesn´t give '0' as result and I don´t know why as one step before it still worked all well.

Re: Listbox as Check box

MK_QSL — Thu, 13 Mar 2014 11:36:15 GMT

I am using the same.

Dont just read the post but check the whole video.

It should definitely work.