topic calculate in a macro in QlikView

calculate in a macro

Thu, 02 Jul 2009 18:59:30 GMT

Hello,

there is an application with a variable, named vstep.

Now I want to edit this variable by a macro. On click on the button the variable should added by 1.

e.g. vstep = 5, now it should be 6, on next click 7 and so on.

How can i realize that?

Thanx

Thu, 02 Jul 2009 19:52:34 GMT

This macro should do the job.

sub test
set v = ActiveDocument.Variables("vstep")

var = v.GetContent.String

w = var + 1

v.SetContent w,true
end sub

Philippe

Thu, 02 Jul 2009 19:58:43 GMT

Perfect,

Thanx

Thu, 02 Jul 2009 19:58:48 GMT

Perfect,

Thanx