topic Re: I cannot call Sub routine from the Module. in QlikView

I cannot call Sub routine from the Module.

Fri, 20 Jan 2017 03:43:58 GMT

Here is the script in the module.

--------------------------------------------------------------------------------------

function NextContractDate(ContractLength,ContractStart)

f = 1

do while f

NextDate = DateAdd("m",ContractLength, ContractStart)

if NextDate < date() then

ContractStart = NextDate

f = 1

else

f = 0

end if

loop

NextContractDate = NextDate * 1

end function

sub C

msgbox NextContractDate(9, 40909)

end sub

function TestMe(a,b)

TestMe = a + b

end function

--------------------------------------------------------------------------------------

Here is the script in the Qlikview document.

Call C

I don't know the reason why I am unable to call sub C from the script. Could you please figure out this issue?

Thank you very much indeed.

Fri, 20 Jan 2017 03:46:00 GMT

The error screen below was populated.

rwunderlich — Fri, 20 Jan 2017 04:37:28 GMT

You cannot call Module Subs from script. The script Call statement calls script subs, not module subs.

You can use Module Functions in script like:

LOAD NextContractDate(ContractLength,ContractStart) as NextContract Date

...FROM xxx;

-Rob

Fri, 20 Jan 2017 05:31:12 GMT

oh. It's clear answer Rob.

Thank you for your answering.