topic macro to replace always one selected option in QlikView

macro to replace always one selected option

Thu, 08 Oct 2009 21:27:11 GMT

I need to create a macro that basically replace the option "always one selected" for a multi box or list box. Either when the document is opened or when a sheet is opened, I want a selection or the first selection of a field in a multi box or list box to be selected. This field should not allow the selection to be cleared but should allow the user to make another selection from the field.

For example, if I have an employee name as a field in a multi-box, then when I open the document or switch to that sheet, the macro should force a name to be selected. I should not be able to clear the selection because at least 1 name should be selected. HOwever, he user should be able to select another name from the list.

I have never created a macro so I am not even sure where to begin. Any help would be greatly appreciated!

macro to replace always one selected option

Thu, 08 Oct 2009 23:09:26 GMT

Hello ,

Attached is the simple example see the document properties _ macros maybe this is the way you are looking for

Talha

macro to replace always one selected option

Anonymous — Fri, 09 Oct 2009 08:51:12 GMT

Just curious - why not to use "always one" option?

macro to replace always one selected option

Fri, 09 Oct 2009 18:06:34 GMT

After the document has been reloaded on the server nothing is selected, so "always one" is not checked.

Marko

macro to replace always one selected option

Fri, 09 Oct 2009 18:25:47 GMT

Hi Marko,

I have seen this "always one selected value" setting removed after reload before. The reason was because the default clear state was set before the "always one selected value" setting was applied. This may be the case in your application too. If it is you will need to apply the setting and set the default clear state again.

Kind Regards

Footsie

macro to replace always one selected option

Fri, 09 Oct 2009 22:52:27 GMT

I see the issue with this loading as well. We also have other issues pertaining to the always one selected as well.

I have been playing around with the macro information provided in the APIquide.QVW but since I am not at all familiar with this stuff, I am struggling. I was playing with things I saw in there such as SearchToggle and SetInputFieldValue but no luck.

macro to replace always one selected option

Anonymous — Sun, 11 Oct 2009 04:19:22 GMT

I see...
In this case I use a macro that selects a default value and sets this "always one" option. Stilla mcro, but a very simple one.

macro to replace always one selected option

Mon, 12 Oct 2009 19:08:49 GMT

That is the macro that I have been trying to create but need some assistance. I was able to figure out that the following macro would select all, a group,or one but only if the specific one you use is in the list which will not always be the case in scenario. I also have not been able to figure out the "always one selected" part of the macro either.

Any assistance with this is much appreciated!

function

{

ActiveDocument.Fields("ResidentName").ToggleSelect("A*")

}

Select()

macro to replace always one selected option

Anonymous — Tue, 13 Oct 2009 06:58:00 GMT

Here is an example for "always one selected" part of the question. You have to make a selection first for this macro to set this property.


Sub SetOnlyOne
 set wk=ActiveDocument.GetField("WeekOf")
 wSel=wk.GetSelectedValues.Count
 if wSel=1 then
 set prop = wk.GetProperties
 prop.OneAndOnlyOne = true
 wk.SetProperties prop
 end if
End Sub

Re: macro to replace always one selected option

Fri, 10 Feb 2012 07:49:14 GMT

Hi,

Where do you call this macro from?

I am working on the same topic, but need to publish my QV file on a QV server

I was considering to trigger this from the PostReload trigger, but I understood the macro will not run as the reload is performed on the server

Then, OnOpen trigger, but the method 'SetProperties' does not seem to be applied.

set prop = wk.GetProperties

prop.OneAndOnlyOne = true

msgbox prop.OneAndOnlyOne

wk.SetProperties prop

msgbox prop.OneAndOnlyOne

will give me 2 'False' result.

Have you experience the same?

I have the same behavior by placing a button which calls the macro.

macro to replace always one selected option

Anonymous — Fri, 10 Feb 2012 13:41:17 GMT

Nicolas,

See another example. Notice thta you must select a value before setting "always one" property. I mentiioned it in my old post, although without example.

Sub SetOnlyOne
' first, select one value (you have to make sure it always exist after reload
' it may look more complex in real app
set a=ActiveDocument.GetField("A")
A.Select "1"
' set "always one selected"
set a=ActiveDocument.GetField("A")
aSel=a.GetSelectedValues.Count
if aSel=1 then
set prop = a.GetProperties
prop.OneAndOnlyOne = true
a.SetProperties prop
end if
End Sub

The macro can be triggered by "post reload" or "on open"

(I tested it, it worked)

Regards,

Michael