topic Macro understanding problem in QlikView

Macro understanding problem

Tue, 14 May 2013 03:58:53 GMT

m new to macro pls anybody explain me wht does this macro means

sub SanctionAmtSettings
set v = ActiveDocument.Variables("v Sanction Loan Amount Range")
v.SetContent "10",true
set v = ActiveDocument.Variables("v Sanction Loan Amount Range1")
v.SetContent "100",true
set v = ActiveDocument.Variables("v Sanction Loan Amount Range2")
v.SetContent "1000",true
set v = ActiveDocument.Variables("v Sanction Loan Amount Range3")
v.SetContent "1000",true
set v = ActiveDocument.Variables("v Sanction Loan Amount First Limit")
v.SetContent "100",true
set v = ActiveDocument.Variables("v Sanction Loan Amount Second Limit")
v.SetContent "1000",true
set v = ActiveDocument.Variables("v Sanction Loan Amount Third Limit")
v.SetContent "10000",true
MSGBOX("Sanction Amt Values Set to Default")
end sub

Re: Macro understanding problem

m_woolf — Tue, 14 May 2013 11:02:17 GMT

The qvw has a list of variables:

v Sanction Loan Amount Range

v Sanction Loan Amount Range1

v Sanction Loan Amount Range2

This macros sets each variable to a default value.

v Sanction Loan Amount Range to 10

v Sanction Loan Amount Range1 to 100

v Sanction Loan Amount Range2 to 1000

Re: Macro understanding problem

Tue, 14 May 2013 11:09:56 GMT

It is assigning values to a list of specific variables.

v Sanction Loan Amount Range = 10

v Sanction Loan Amount Range1 = 100

and so on...