topic Re: Loop in Skript detected in QlikView

Loop in Skript detected

Stefan_Weber — Wed, 11 Mar 2020 11:25:05 GMT

Hello,

I am trying to set up a new Qlikview application. I have multiple Dimension Tables and 3 Data Tables. I already concatenated 2 of them into one table. But the 2 remaining tables have a YearMonth field which is, according to my understanding, causing a Loop. I have uploaded my current Table structure for your reference. Do you have a suggestion how I can break the Loop.

Thanks for your help.

Stefan

Re: Loop in Skript detected

Brett_Bleess — Tue, 07 Apr 2020 20:36:56 GMT

You would need to use Qualify function on one of the fields to prevent the auto linking:

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

You could also change the name of the field in one of the tables as well, that is basically what Qualify is doing by appending the table name to the fieldname...

The following Design Blog post may be of some use too:

https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

Regards,
Brett

Re: Loop in Skript detected

Stefan_Weber — Wed, 08 Apr 2020 09:26:38 GMT

Hi Brett,

thanks for your reply, I did something similar in the meantime, I just renamed the fields during the load statement. Loop is now gone.

Thanks

Stefan