topic Re: List box properties in QlikView

List box properties

alec1982 — Fri, 09 Nov 2012 17:21:43 GMT

Hi guys,

I have a list box where I needed to give the user the ability to select only one value which is an option available on the general tab--> "Always One Slected value"

How can I make the list box to be cleard off when the user moves to other tabs.

Note that I have a clear all trigger on the sheets but because of the One Selected Value that list box is not getting cleared off.

Anybody has an idea?

Thxs for your help

Alec,

Re: List box properties

MayilVahanan — Fri, 09 Nov 2012 17:45:14 GMT

Use in macro:

Sub AlwaysOneSelected

set obj = ActiveDocument.GetSheetObject("LB02")

set boxfield=obj.GetField

set fprop = boxfield.GetProperties

fprop.OneAndOnlyOne = True

boxfield.SetProperties fprop

End Sub

Sub RemoveAlwaysOneSelected

set obj = ActiveDocument.GetSheetObject("LB02")

set boxfield=obj.GetField

set fprop = boxfield.GetProperties

fprop.OneAndOnlyOne = False

boxfield.SetProperties fprop

ActiveDocument.ClearAll True

End Sub

I learn from Deepak Vadithala from this post:

http://community.qlik.com/message/154380#154380

Hope it helps u also..

Re: List box properties

alec1982 — Fri, 09 Nov 2012 19:00:42 GMT

Hi,

thanks for the information.

I have never created macros yet.

May you please tell me where should I type the script that you provided ?

Thxs again

Alec,

Re: List box properties

MayilVahanan — Fri, 09 Nov 2012 19:06:22 GMT

PFA

Re: List box properties

alec1982 — Fri, 09 Nov 2012 19:13:50 GMT

Hi,

Thxs again for the sample. it is exactly what I am looking for but I don't know how to create the Macro.

I know how to call it if it is already created but don't know how to create it.

I appreciate it if you can provide how to create a macro

Thxs,

Alec

Re: List box properties

alec1982 — Fri, 09 Nov 2012 19:15:38 GMT

I also know how to access the Edit Module but don't know how to add the macro

Thxs,

Re: List box properties

MayilVahanan — Fri, 09 Nov 2012 19:19:01 GMT

Please see the sheet properties -> Trigger ..

edit actions...

In that u can see what you want..

Hope it helps

Re: List box properties

alec1982 — Fri, 09 Nov 2012 19:21:07 GMT

Thxs, I got it.

My question was where should I type the script in theedit Module. I just copied it there and everything is working.

Have a wonderfull weekend!

Alec

Re: List box properties

alec1982 — Fri, 09 Nov 2012 20:33:47 GMT

Hi again,

I am still getting an issue.

When I apply the macro on a trigger it works but at the same time I loose all the other triggers on the same sheet.

The triggers that I have on the sheet are listed after the macro run and they are selections on different fields.

I appreciate any help!

Thxs,

Alec

Re: List box properties

MayilVahanan — Fri, 09 Nov 2012 20:37:51 GMT

Demote the macro trigger at last n tested once..

May be it helps

Re: List box properties

alec1982 — Fri, 09 Nov 2012 20:52:39 GMT

It didn't help.

Thxs,

Alec

Re: List box properties

MayilVahanan — Fri, 09 Nov 2012 20:57:21 GMT

can you post a sample file?

Re: List box properties

CELAMBARASAN — Fri, 09 Nov 2012 21:18:04 GMT

Hi,

By using macro for only one selected value or none selected you can achieve this

Check the attached.

Use clear all and check it

Re: List box properties

alec1982 — Fri, 09 Nov 2012 21:20:27 GMT

Hi, Thanks for the sample.

It is the same sample that I've got before where I am having the issues.

Best,

Badr

Re: List box properties

CELAMBARASAN — Fri, 09 Nov 2012 21:26:33 GMT

You can do this using alternate states if your using QV11.

Check the attached