topic Variables not being set in QlikView

Variables not being set

Mon, 08 Aug 2011 04:49:44 GMT

Good Day,

I have an interresting occurence with one of my models. I use input boxes (tried it with calendar sliders with same result) that use variables (to get a Date Range from a loaded field). Everyhting works fine, except that I have to click on a list box - that contains the loaded date field (or funny enough - the clear selections button) after making selections before the changes takes place. I suspect it has something to do with the Triggers - I have tried to use Select Object in my variable change - as well as Clear All Selections (to automate the "manual workaround") with no avail. Does anyone perhaps have an idea to set me in the right direction please?

Variables not being set

Tue, 09 Aug 2011 21:38:57 GMT

I have sorted it out. In triggers I added an on change event for my variables vStartDate and vEndDate. The Subroutine looks like this:

Sub SelectDates

vClick_Begin_Date = ActiveDocument.Variables("vStartDate").GetContent.String
vClick_End_Date = ActiveDocument.Variables("vEndDate").GetContent.String

if vClick_End_Date<vClick_Begin_Date then
vClick_End_Date=vClick_Begin_Date
set v = ActiveDocument.GetVariable("vEndDate")
v.SetContent vClick_End_Date,true
end if

ActiveDocument.Fields("Date").Select ">="&(vClick_Begin_Date)&"<="&(vClick_End_Date)
end sub

Variables not being set

Tue, 09 Aug 2011 21:54:32 GMT

It just dawned on me. I think what might have actually really solved the problem was In the Security tab under Document properties I have chosen "Macro overrides security"