topic Re: Subroutine in QlikView

Subroutine

alec1982 — Mon, 11 Jan 2016 05:16:48 GMT

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;

Re: Subroutine

Anonymous — Mon, 11 Jan 2016 05:31:59 GMT

may be helpful for you?

Qlikview Scripting Inheritance Concepts

Re: Subroutine

tresB — Mon, 11 Jan 2016 05:37:19 GMT

I didn't get any error running this script snippet.

Re: Subroutine

jagan — Mon, 11 Jan 2016 05:37:43 GMT

Hi,

Try like this

Sub ScanData (index, SetOfFile)

If index = 1 THEN

table2:

Load * inline [

];

ENDIF

Concatenate(table2)

Load '$(SetOfFile)' as SS

AutoGenerate (1);

End Sub

ListOfFiles:

Load * inline [

Files

ABC

ASD

AQW

AQSW

];

ListOfFiles:

Load * inline [

ListOfFiles

AluminiumPrimia-A

AluminiumPrimia-B

CopperPrimia-A

CopperPrimia-B

];

Let vNumofFiles = noofrows('ListOfFiles');

For i= 1 to $(vNumofFiles)

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

Call ScanData(i, vSetofFiles)

Next;

Hope this helps you

Regards,

Jagan.

Re: Subroutine

PradeepReddy — Mon, 11 Jan 2016 05:38:57 GMT

can you explain, what you are trying to achieve ? What would be your output?

Re: Subroutine

alec1982 — Mon, 11 Jan 2016 05:39:37 GMT

thank you guys,

I made some changes to the question..

it doesnt give an error now but it return null values too if you debug it..

Re: Subroutine

jagan — Mon, 11 Jan 2016 05:44:54 GMT

HI,

Did you tried the script which I posted? It is working for me.

Regards,

Jagan.

Re: Subroutine

rajeshforqlikvi — Mon, 11 Jan 2016 05:50:10 GMT

Hi Please follow be below link:

Code Reusability in QlikView and Debugging QlikView Scripts - YouTube

Regards

Rajesh Kumar

Re: Subroutine

tamilarasu — Mon, 11 Jan 2016 05:53:37 GMT

Try,

ListOfFiles:
Load * inline [
Files
ABC
ASD
AQW
AQSW
];

Sub ScanData

let vss = vSetofFiles ;

End Sub

Let vNumofFiles = noofrows('ListOfFiles');
For i= 1 to $(vNumofFiles)
Let vSetofFiles = fieldvalue('Files',$(i));
Call ScanData
Next;

BTW, What is your exact requirement.?

Re: Subroutine

tresB — Mon, 11 Jan 2016 06:03:45 GMT

Which null are you talking about? The one returned by the following statement?

let vss = $(vSetofFile)

If so, it's obvious, because variable vSetofFile is not defined before you use it here. And in the snippet, you don't use vss either. So you can probably remove that line itself. I am not sure if you meant something else.

Re: Subroutine

Digvijay_Singh — Mon, 11 Jan 2016 07:13:36 GMT

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;