topic Re: Database relationship and date loop in QlikView

Database relationship and date loop

darren_dixon — Fri, 15 Feb 2013 08:40:31 GMT

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 — Fri, 15 Feb 2013 08:49:14 GMT

try to rename operative number field in Zues PersIn table

darren_dixon — Fri, 15 Feb 2013 08:52:22 GMT

Hi Sushil,

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

sushil353 — Fri, 15 Feb 2013 09:03:25 GMT

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