topic Re: External dll as base for user defined vb functions in QlikView

External dll as base for user defined vb functions

Tue, 24 Jun 2014 18:36:07 GMT

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

Re: External dll as base for user defined vb functions

Tue, 24 Jun 2014 20:09:37 GMT

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

Re: External dll as base for user defined vb functions

Tue, 24 Jun 2014 21:02:56 GMT

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.

Re: External dll as base for user defined vb functions

Thu, 26 Jun 2014 12:06:21 GMT

No other ideas community?

Re: External dll as base for user defined vb functions

jhamard — Tue, 12 Jul 2016 15:38:25 GMT

It's possible !

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

🙂