Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

karelibarcar
New Contributor III

Resolve a Circular Loop

Hi everyone,

Can you please help me how I can resolve this circular reference? because I need the link fc_Interacciones with con_Operacion_Reclamo_tmp2 using Cod_Grupo_Usuario and also the link with con_OperacionOrigen using Descripcion_Gestion. The link between con_OperacionOrigen and con_Operacion_Reclamo_tmp2 using Cod_Operacion is very important.

Do you have any ideas?

rc.png

8 Replies
JustinDallas
Valued Contributor

Re: Resolve a Circular Loop

Hello Karen Barbarian,

I'm suffering from a similar issue right now.  Generally, I try to either LEFT JOIN or CONCATENATE the tables if that makes sense when considering the datamodel and the questions that will be asked of it.  You could try taking the necessary combinations, and making a master join table, but that doesn't seem to pass the smell test in my opinion.

karelibarcar
New Contributor III

Re: Resolve a Circular Loop

Exactly, I have already used Concatenate the tables and used link tables but this completely alters the information, it produces too many nulls. Join still avoided using it because I fear that it could alter it even more.

adityaakshaya
Contributor III

Re: Resolve a Circular Loop

Hi Karen,

You can use Qualify to remove circular loop here. You can use Qualify <Fieldname>; before the table. this will help to remove circular loop.

Regards,

Akshaya

karelibarcar
New Contributor III

Re: Resolve a Circular Loop

Thanks for your suggest, Is that the same that rename the field?

adityaakshaya
Contributor III

Re: Resolve a Circular Loop

Yes, Either you rename the field or Use Qualify. Using Qualify can help you get schema name before your field name.

Regards,

Akshaya

karelibarcar
New Contributor III

Re: Resolve a Circular Loop

Oh! but I'm afraid that does not work for me because I need the link to exist, because each Cod_Grupo_Usuario has the same Cod_Gestion and that's why I need to identify the Cod_Grupo_Usuario

dwforest
Valued Contributor

Re: Resolve a Circular Loop

Use ApplyMap to get the Gestion into tmp2?

delroekid
Contributor

Re: Resolve a Circular Loop

Remove or rename the field COD_Grupo_Usiariou in the _tmp2 table.

Community Browser