topic Re: Loop issue in QlikView

Loop issue

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I have the attached looping issue in my code.

Is there something obviously wrong with my code?

Any help is much appreciated.

Regards,
Daniel

kaushiknsolanki — Thu, 20 Feb 2020 15:31:35 GMT

There seems to be a problem with your scripting.

Check below link to understand how to remove the sync tables and remove the loop.

danielnevitt — Thu, 20 Feb 2020 15:57:56 GMT

Thanks for the quick reply.

Is there a simple way to remove the auto join on fields to only a few specified ones?

Thanks,
Daniel

Brett_Bleess — Wed, 25 Mar 2020 19:39:59 GMT

Here is a Design Blog post regarding synthetic keys and tables that may be helpful:

I believe the 'quick' solution you wanted may be the following script function:

Here is its counterpart:

Hopefully this will help you get things sorted.

Regards,
Brett