Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro understanding problem

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

Labels (1)
2 Replies
m_woolf
Master II
Master II

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


Not applicable
Author

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...