topic AW:Create a personal function in QlikView

Create a personal function

Thu, 26 Nov 2009 17:09:33 GMT

Hi everyone!

I've been working with QV for some weeks and this is my first post.

I want to know how to stablish personal functions in QV to call them on Load part.

For example:

Function Calc (...);

Load Calc (Customer_type) as NewType

From qvd (qvd)

where Customer_type = 1;

Is possible to do this?

Thanks a lot

AW:Create a personal function

rbecher — Thu, 26 Nov 2009 17:29:59 GMT

Hi,

you can only create personal functions in VB script which can be used in QV script.

function calc (ByVal customer_type)
 ... do something
 calc = result
end function

But I would suggest always to try to use build in script functions first for performance reasons.

- Ralf

AW:Create a personal function

Thu, 26 Nov 2009 18:07:33 GMT

For that performance reasons I prefer to do that in QV, but seems that it's not possible to do a function at the begining of the QV script to be called after.

Thank you, Ralf.

AW:Re: AW:Create a personal function

rbecher — Thu, 26 Nov 2009 18:11:28 GMT

You can do a lot of interesting things with QV mappings...

- Ralf

AW:Re: AW:Create a personal function

Thu, 26 Nov 2009 18:59:06 GMT

I think you can also do some kinf of function using sub() for example.

But in this case you can only do QV things such as calculate specific values in tables, create tables, update variables, etc..

Sébastien

AW:Re: AW:Create a personal function

Thu, 26 Nov 2009 19:49:56 GMT

Sébastien, sub function seems good, but it's not possible to use "call" into load part.

"Load call function(parameter) as result_function From file.qvd (qvd)"

I want to do something like that...

Thanks! 🙂

AW:Re: AW:Create a personal function

Thu, 26 Nov 2009 20:01:07 GMT

You're right but in some case you can do a loop and for each loop retrieve the result in a variable then use this variable in the field...

I don't know if it can be an easy solution comparing to vbs but why not..

AW:Create a personal function

rbecher — Fri, 27 Nov 2009 00:49:19 GMT

Pepe,

I found another way to do this in the forum: http://community.qlik.com/forums/p/18140/70878.aspx#70878

Also see the attached example udf.qvw!

- Ralf

AW:Create a personal function

Fri, 27 Nov 2009 01:38:24 GMT

No Attachments 😞

AW:Re: AW:Create a personal function

rbecher — Fri, 27 Nov 2009 02:23:36 GMT

follow the link...

Re: Create a personal function

farolito20 — Fri, 11 Jan 2013 16:01:23 GMT

Do you know how to load form a qvd in vbscript?

Re: Create a personal function

martin59 — Fri, 11 Jan 2013 16:04:57 GMT

I answer you in this post.

You can use your SQL request in QlikView.

Or transform it in AQL, the QlikView language.

Martin Favier