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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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

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