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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
MVP
MVP

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;