Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
raynac
Partner - Creator
Partner - Creator

Macro to select "Always One Selected Value"

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!

1 Solution

Accepted Solutions
Anonymous
Not applicable

2 Replies
Anonymous
Not applicable

raynac
Partner - Creator
Partner - Creator
Author

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.