topic Triggering a macro on the evaluation of an expression variable in QlikView

Triggering a macro on the evaluation of an expression variable

Mon, 10 Oct 2011 12:23:42 GMT

Hi All,

I need a document variable event 'on change' trigger to run a macro, my problem is that the variable is an expression, the triggers only seem to work when the actual value contained in the variable changes.

this is my variable

vWeeklyMonthly

which contains

=if(GetCurrentField(date_dimension) = 'Week Ending','Weekly',if(GetCurrentField(date_dimension)='Month Year','Monthly'))

I need to trigger my macro when the expression in the variable changes from 'Monthly' to 'Weekly' or vice versa.

does anyone know how to achive this?

Thank you

Triggering a macro on the evaluation of an expression variable

Mon, 10 Oct 2011 18:30:09 GMT

Try to use a 2nd variable that equals the first then set the trigger to run on that variable change.

So something like this:

vCalc = if(Sum(Rate) > 0, 'True', 'False')

vAns = $(=vCalc)

then set the trigger to run when vAns changes.

Triggering a macro on the evaluation of an expression variable

Tue, 11 Oct 2011 08:26:37 GMT

This doesn't work unfortunately, it would seem that the content of the variable needs to change e.g. from 1 to 0

as the expression itself never changes it doesn't trigger the macro.

Re: Triggering a macro on the evaluation of an expression variable

Tue, 11 Oct 2011 15:31:07 GMT

I made a little demo... it seems to be working. Maybe I missunderstood the question?

Re: Triggering a macro on the evaluation of an expression variable

Wed, 12 Oct 2011 09:25:25 GMT

Your example works perfectly, I think the problem arises when trying to trigger a macro on a expression which is the result of a cyclic group. I've attached a file

which demonstrates this.

Previous discussion on topic :

Trigger on Cyclic groups

Re: Triggering a macro on the evaluation of an expression variable

Wed, 12 Oct 2011 16:30:45 GMT

So if I understand correctly... You want to trigger a macro when the cyclic group changes? Yes? If that is correct then you should be able to just add a trigger to the variable you set up (vCalc2) and it will run the macro code. Am I understanding correctly now or am I still missing the idea?

Triggering a macro on the evaluation of an expression variable

Thu, 13 Oct 2011 09:58:48 GMT

That's exactly what I'm trying to do. Unfortunatley adding a trigger to vCalc2 doesn't seem to work, if you click the

cyclic group in 'zack_2.qvw' the macro does not trigger.

Re: Triggering a macro on the evaluation of an expression variable

Thu, 13 Oct 2011 15:56:13 GMT

That's very strange... on my version of zack_2 it works. Everytime you change the cyclic group from 'Name' to 'Sex' or vice versa it runs the macro. What version of QlikView are you using?

Mine is: 10.00.9061.7 SR3 64-bit

Re: Triggering a macro on the evaluation of an expression variable

Fri, 14 Oct 2011 08:28:07 GMT

10.00.8935.7 SR2 32 - bit

Please don't tell me this is yet another bug!

Re: Triggering a macro on the evaluation of an expression variable

Fri, 14 Oct 2011 15:06:27 GMT

Well it looks like it may be...

All I did was change the cyclic group...