Discussion board where members can get started with QlikView.
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
Use in macro:
set obj = ActiveDocument.GetSheetObject("LB02")
set fprop = boxfield.GetProperties
fprop.OneAndOnlyOne = True
fprop.OneAndOnlyOne = False
I learn from Deepak Vadithala from this post:
Hope it helps u also..
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 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
I also know how to access the Edit Module but don't know how to add the macro
Please see the sheet properties -> Trigger ..
In that u can see what you want..
Hope it helps
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!
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!
Demote the macro trigger at last n tested once..
May be it helps