topic Field Issue in QlikView

Field Issue

pgalvezt — Wed, 01 Jun 2016 19:53:15 GMT

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!!

Re: Field Issue

Peter_Cammaert — Wed, 01 Jun 2016 20:01:07 GMT

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

Re: Field Issue

santiago_respane — Wed, 01 Jun 2016 20:01:59 GMT

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,

Re: Field Issue

pgalvezt — Wed, 01 Jun 2016 20:10:42 GMT

Hi Santiago,

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

Re: Field Issue

pgalvezt — Wed, 01 Jun 2016 20:18:10 GMT

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...

Re: Field Issue

santiago_respane — Wed, 01 Jun 2016 20:26:25 GMT

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,

Re: Field Issue

pgalvezt — Wed, 01 Jun 2016 20:43:32 GMT

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...

Re: Field Issue

santiago_respane — Wed, 01 Jun 2016 21:00:54 GMT

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,

Re: Field Issue

pgalvezt — Wed, 01 Jun 2016 21:11:25 GMT

Unfortunately I can not do that.

Re: Field Issue

Anonymous — Thu, 02 Jun 2016 08:05:38 GMT

Hi Pablo,

Try this.

Kind regards

Re: Field Issue

pgalvezt — Thu, 02 Jun 2016 14:12:24 GMT

All values budget goes to 0. But Your Idea within Santiago Ideas they help me out to do another concatenate. And Works fine to periods. Now just I have to join Id CeCo. Can you help me to join the better way this field? Although I get to join Id CeCo To the 2 big tables I think is no the better way...