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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Subroutine

hi,

trying to get subroutine called to use variable value.. the variables is set from a column using for. but getting errors.. any idea?

ListOfFiles:

Load * inline [

Files

ABC

ASD

AQW 

AQSW 

];

Sub ScanData

let vss = $(vSetofFile) ;

End Sub

Let vNumofFiles = noofrows('ListOfFiles');

For i= 1 to $(vNumofFiles)

Let vSetofFiles = fieldvalue('ListOfFiles',$(i));

Call ScanData

Next;

Labels (1)
10 Replies
Digvijay_Singh

Try single quote around vSetOfFiles in subroutine as below -

ListOfFiles:

Load * inline [

Files

ABC

ASD

AQW

AQSW

];

Sub ScanData(vSetOfFiles)

  let vss = '$(vSetOfFiles)';

End Sub

Let vNumOfFiles = NoOfRows('ListOfFiles');

For i = 1 to $(vNumOfFiles)

  Let vSetOfFiles = FieldValue('Files',$(i));

  Call ScanData(vSetOfFiles);

Next;