topic Re: Function Issue? in QlikView

Function Issue?

Sokkorn — Thu, 22 Sep 2011 09:29:45 GMT

Hi All,

I create one function in module. It work well when I use in load script. But the problem is when I use in Expression then I got null value. What wrong with this? Anyone know how to create function to use in Expression?

Regards,

Sokkorn

Function Issue?

jonathandienst — Thu, 22 Sep 2011 09:58:38 GMT

I know you can use them in the load script, but can you use module functions in expressions?

I have never managed to get that working (OK I only tried once, without success).

Regards

Jonathan

Function Issue?

Sokkorn — Thu, 22 Sep 2011 10:12:58 GMT

Hi Jonathan,

Thanks for your reply.

I cannot use module functions in expression. What I am looking for is how can I use module function in expression?

Regards,

Sokkorn

Function Issue?

jonathandienst — Thu, 22 Sep 2011 18:33:57 GMT

Sokkom

What I am saying is that I don't think that is possible - but I may be wrong.

Regards

Jonathan

Re: Function Issue?

Sokkorn — Fri, 23 Sep 2011 01:03:59 GMT

Hi Jonathan,

You are right. Now I decide to use module function in load script. But the performance too much poor (take 2 or 3 sec for fetch 1 record). Please take a look with attahced file and help me to modify the function to get the same result and better performance.

Appreciate for your help.

Regards,Sokkorn

Re: Function Issue?

jonathandienst — Fri, 23 Sep 2011 15:08:24 GMT

Sokkorn

The problem is that the looping in the module code. Each call loops up to 20million times (average 10million). I don't know much about erlangB calcs, but I do not believe that the the script should loop so many times. I would check the erlang scripts on the internet and pay attention to your looping limits and test conditions.

The attached modification of your model shows how I tested this.

Regards

Jonathan