Solved: Re: Loop issue - Qlik Community

danielnevitt · ‎2020-02-20

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

Brett_Bleess · ‎2020-03-25

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

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

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

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Here is its counterpart:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Hopefully this will help you get things sorted.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

kaushiknsolanki · ‎2020-02-20

There seems to be a problem with your scripting.

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

https://www.youtube.com/watch?v=ANKIdUubzbE

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

danielnevitt · ‎2020-02-20

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 · ‎2020-03-25

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

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

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

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Here is its counterpart:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Hopefully this will help you get things sorted.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.