topic Macro randomly does not set variable? in QlikView

Macro randomly does not set variable?

Wed, 06 Apr 2011 19:08:51 GMT

Greetings.

I have a macro that sets variables that is setting a start and end age:

ActiveDocument.Variables("vAgeEnd").SetContent "63", true
ActiveDocument.Variables("vAgeStart").SetContent "23", true

There are all sorts of age ranges that it sets, based on a number of things in the system. Occasionally, it will set one age, and not the other. I found that if I changed the order of the settings (Usually I set vAgeStart first, then the vAgeEnd) it "fixes" the problem, but then later on, if I happen to be coming from a particular selection, it won't work. In some cases, in the one macro, I set these two variables more than once.

Has anyone ever seen anything like this? Is it a known problem? Its killing me, because I'm constantly rechecking my code, thinking I've programmed something wrong.

Thanks.

Macro randomly does not set variable?

Anonymous — Wed, 06 Apr 2011 20:20:13 GMT

Sally,
Try to insert WaitForIdle or Sleep before each variable setting.

Macro randomly does not set variable?

Wed, 06 Apr 2011 21:00:53 GMT

I tried with WaitForIdle, but didn't seem to make a difference (other than generally slowing down the screen). But I may have not tried it before each setting. I'll give that a try and see what happens.

Macro randomly does not set variable?

Thu, 07 Apr 2011 17:37:38 GMT

Did the following:

ActiveDocument.GetApplication.WaitForIdle 3000
ActiveDocument.Variables("vAgeEnd").SetContent "1", true
ActiveDocument.GetApplication.WaitForIdle 3000
ActiveDocument.Variables("vAgeStart").SetContent "1", true
ActiveDocument.GetApplication.WaitForIdle 3000

And vAgeEnd remained the 999 it was before executing these statements.

Macro randomly does not set variable?

Thu, 07 Apr 2011 21:04:21 GMT

DUH.

I forgot I had constraints on these. If the new vAgeStart date was greater than the current vAgeEnd, it wouldn't update the variable (but I got no warning message like if I tried to do it manually). So. I check for the old values before adding the new values and it all works file.