Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 

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
Champion III
Champion III

2 Replies
Champion III
Champion III


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.