topic Re: Macro to select "Always One Selected Value" in QlikView

Macro to select "Always One Selected Value"

raynac — Thu, 18 Jun 2015 20:54:28 GMT

Hi All,

I am writing a macro to use as a Load Trigger to make a selection in a field.

Sub IncludeGrpblock
ActiveDocument.Fields("Group Block").Clear
ActiveDocument.Fields("Group Block").Select("Include")
end sub

Nice and simple, right? The issue is, once this occurs, I want to make the checkbox below selected by default. (I do a "Reduce Data" on my views to distribute them as I have many clients and we need to make sure there is no data in them when we give them out, This process, of course, clears that check box.)

Is there any way to set this setting on load, after I have forced a selection?

Thanks in advance!

Re: Macro to select "Always One Selected Value"

Anonymous — Thu, 18 Jun 2015 21:05:02 GMT

See the solution here:

macro to replace always one selected option

Re: Macro to select "Always One Selected Value"

raynac — Thu, 18 Jun 2015 21:26:16 GMT

Thank you SO much, Michael...you are the best!

I knew there had to be a way to do this but I just didn't know the name of the property to set in the macro.