Database relationship and date loop - Qlik Community

darren_dixon · ‎2013-02-15

Hi all,

I'm hoping someone can help me with the setup of my Qlikview document.

I'm trying to achieve the following with my Appointment table being the main table.

Appointments > Job Costs

> First Touch Profiles > Zues PersIn > Zues Result

> Non_Opti_App

I've tried Left/Right joins etc. but getting nowhere and getting a loop with the 'Actual Start' (Date field)

Thanks in advance for any help.

Darren

sushil353 · ‎2013-02-15

try to rename operative number field in Zues PersIn table

darren_dixon · ‎2013-02-15

Hi Sushil,

Thanks for your reply. The Operative Number is the main link between all three tables. Unfortunately I can't rename this

sushil353 · ‎2013-02-15

Hi darren,

your problem is circular reference. qlikview handle this situationby by loosely coupled tables.

you should try to create the link table. use reference manual to know about link tables.

i have one post link, may be it will help you out.

If you upload your sample application then i can try to solve it.

HTH

Sushil