Field Issue

[pgalvezt]

Hello,

I've trying to join a field into my QlikView modelo, But I can´t get it.. All Possible Joins give me a Circular Reference. How is the better way to join Id CeCo with Id CeCo1? Please Advice me Thank you!!

[Peter_Cammaert]

See if you can concatenate table 'RemuneracionesGedtion' to table 'RemuneracionesRemGL'.

Am I right in assuming that table 'PeriodoGL' contains just a calendar and some common dimensions?

Peter

[santiago_respane]

Hi,

Have a composite key with Ceco1 and Key Fecha in order to link them directly.

Your keys should look like this:

RemuneracionesGestion

Id.Cod.CeCo1 & KeyFecha1 as superKey

Id.Cod.CeCo1

RemuneracionesREMGL

Id.Cod.CeCo & KeyFecha as superKey

KeyFecha

PeriodoGL

KeyFecha

Agrupacion_CeCoGLGestion

Id.Cod.CeCo1

Please let me know if this helps or if you need more elaboration.

Kind regards,

[pgalvezt]

Hi Santiago,

I followed your method but again I have Circular Reference Problems.

[pgalvezt]

Budget also is concatenated to Remuneraciones.

I have 2 Budgets and 2 Remuneraciones Tables. I concatenated Budget 1 with remuneraciones 1 and Budget 2 with Remuneraciones 2. I get to concatenate all tables but I loose the budget...

[santiago_respane]

Hi,

My bad, i wasn't too clear.

You have KeyFecha and KeyFecha1, are those the same?

If yes, you need to break the relation between PeriodoGL and RemuneracionesRemGL or the relation between PeriodoGL and RemuneracionesGestion, as both tables are related via RemuneracionesGestion.

You can do this by deleting the KeyFecha in PeriodoGL.

If they are not the same, you can join both tables by the composite key "superkey" and then have only one field linked to the PeriodoGL

Let me know your results.

Kind regards,

[pgalvezt]

ou have KeyFecha and KeyFecha1, are those the same? Are The Same. They are used to join Budget.

Ok Reference is gone now. but I can't see the budget values in my dashboard. I put an Qlikview example for better understanding...

[santiago_respane]

Share an image of the dashboard with missing data in which fields, because if we lost info when breaking relations it will be better to join both big tables into one and then make the correct associatation with budget periods.

Kind regards,

[pgalvezt]

Unfortunately I can not do that.

[Anonymous]

Hi Pablo,

Try this.

Kind regards