Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

External dll as base for user defined vb functions

Hello all,

I have an external dll file that contains some functions that I need to use to transform data. I do not have the functions available elsewhere. I have succesfully used this DLL file in Excel where you would use a module like this:

Declare Sub Lambert08ToLambert72 Lib "C:\Program Files\NGI\WINDOWS\32bits\ETRS89_LAMBERT_UTM_32bits.dll" (ByVal xi As Double, ByVal yi As Double, ByVal Hi As Double, ByRef xo As Double, ByRef yo As Double, ByRef Ho As Double)

Function NGI_Lambert08ToLambert72(x As Double, y As Double) As Variant

    Dim xo, yo, Ho As Double

    Call Lambert08ToLambert72(x, y, 100, xo, yo, Ho)

    NGI_Lambert08ToLambert72 = Array(xo, yo)

End Function

Is there a way to do the same in QlikView?

Thanks

Mathias

4 Replies
Not applicable

Re: External dll as base for user defined vb functions

I believe, you can create the USER defined functions and call this functions just like other predefined functions.

Not applicable

Re: External dll as base for user defined vb functions

Thank you dathu for your suggestion but with the script above i get an error when i leave the macro module. It seems qlikview is unable to recognise the first line.

Not applicable

Re: External dll as base for user defined vb functions

No other ideas community?

jhamard
New Contributor III

Re: External dll as base for user defined vb functions

It's possible !

Look at my post : Calling a DLL function in my QV script ...

:-)

Community Browser