topic Re: Custom function in Include file in QlikView

Custom function in Include file

Wed, 14 Jan 2015 16:51:25 GMT

I know you can have sub routines in an Include file such as...

sub something(param1, param2)

...qlikview code

end sub

Can you put a custom function in an Include file such as...

function GetSP(DocLibrary, DocName)

Let vTitle = Title;

Let vLeafName = LeafName;

Tab1:

load max(TimeLastWritten) as MAXTimeLastWritten

from X:\TSollenberger\_QVDs\Layer1\PRD_SP_DocumentInfo.qvd (qvd)

where tp_Title = '$(vDocLibrary)'

and LeafName = '$(vDocName)';

LET v_MAXTimeLastWritten = Date(peek('MAXTimeLastWritten'), '$(TimestampFormat)');

GetSP = vMAXTimeLastWritten

end function

Thanks in advance for any assistance.

Re: Custom function in Include file

consenit — Wed, 14 Jan 2015 16:58:12 GMT

Hi there.

As far as I know there are no user-defined functions in the script, only subroutines.

You can, however, define your functions in a macro module and call them from your script.

Kind regards,

Rrnesto.

Re: Custom function in Include file

marcus_malinow — Wed, 14 Jan 2015 17:00:07 GMT

As Ernesto mentions, functions can be written as macros, however I personally try to avoid macros. One way to achieve something similar might be to write a subroutine, and use it to set a variable. This can then be used in your script.

Re: Custom function in Include file

Clever_Anjos — Wed, 14 Jan 2015 19:26:21 GMT

Easy way is using a Sub, as you are used to setting a variable

Sub GetSP(DocLibrary, DocName)

Let vTitle = Title;

Let vLeafName = LeafName;

Tab1:

load max(TimeLastWritten) as MAXTimeLastWritten

from X:\TSollenberger\_QVDs\Layer1\PRD_SP_DocumentInfo.qvd (qvd)

where tp_Title = '$(vDocLibrary)'

and LeafName = '$(vDocName)';

LET v_MAXTimeLastWritten = Date(peek('MAXTimeLastWritten'), '$(TimestampFormat)');

LET vGetSPReturn = vMAXTimeLastWritten

end Sub