topic Re: Subroutine - I'm missing some little thing in QlikView

Subroutine - I'm missing some little thing

datanibbler — Wed, 08 Oct 2014 15:54:23 GMT

Hi,

I have built a subroutine before, but only once. Now I have a code that is necessary to cleanse the data we get from our customer.

The code works fine on one record - but in reality, there might of course be more than one, and it might not be the first.

=> So I need a subroutine that I can call once for every record.

It's there I am currently failing: When I click through the script in debugging_mode, QlikView reads the "sub" line, but it seems to skip all the steps inbetween and jump directly to the "end sub".

Can someone help me? I am already comparing it to the app where I built a subroutine and I can't spot a relevant difference.

Thanks a lot!

Best regards,

DataNibbler

Re: Subroutine - I'm missing some little thing

Clever_Anjos — Wed, 08 Oct 2014 16:21:01 GMT

You need a subroutine to be called to every record on a load command? Please read this blog post http://community.qlik.com/blogs/qlikviewdesignblog/2014/10/03/teaching-the-load-script-new-tricks

Re: Subroutine - I'm missing some little thing

datanibbler — Wed, 08 Oct 2014 16:47:52 GMT

Hi,

sorry, but following that link I cannot find it.

Anyway - the subroutine seems to work now.

Only, when I go through the script step_by_step, I get an error in the calling_code.

That goes like this:

// I have that variable and in my testing scenario, it has the value 2

For i = 1 TO $(v_Nr_Rows_Multi)
CALL Datensatzcleansing (i)
next

Can you tell me what's wrong about that? I can't spot anything.

P.S.: The subroutine should thus fire twice, it does so once - and then stops.

Re: Subroutine - I'm missing some little thing

Clever_Anjos — Thu, 09 Oct 2014 03:06:41 GMT

Could you post your subroutine code?

Let me take a look