Breaking Circular loop

[Anonymous]

Hi,

I am new to Qlikview.

I learnt that Qlikview uses Associative property so we cannot keep circular relationship like SQL.

In SQL even if there is circular relationship then we can use joins in our query and get required report.

Please let me know how to do it in Qlikview

I am having three tables

Leads

Calls

Executives

All three are related and I cannot break even a single link due to following reasons:

A Lead is assigned to Executives

Calls are made to lead and calls table has lead id and executive id to tell who made the call.

Executives Table has leadid and call id.

Problem being that a executive may call a lead that he is not been assigned as well. So I cannot break any of the link. (as many may think of breaking the Executives and Calls link)

I will share the qvw if that would help.

Thanks

[its_anandrjs]

Hi,

From my side you have to make two table as single table like

1. Calls and Leads or other one

2. Executive and Leads

by joining with its id

Regards,

Anand

[Anonymous]

Thanks,

But in the process of join u broke a link. I am not able to find the assigned executive to a lead.

Link from Leads to Executives is broken. this can be done without a join by just breaking a link.

Please help. I have attached the excel sheet as well.

[Anonymous]

Thanks Anand.

I tried doing that as well but the problem is I need Loop is not broken.

Can u see the other posts by Mayil. He has also mentioned the same but in the process a link is getting broken which I cant do.

I have shared the qvw and data excel file.

Pleasssse help

[MayilVahanan]

HI

I think attached file helps you..

[CELAMBARASAN]

Hi,

You go with creating fact tables or link tables

for more information please read this article

http://www.quickqlearqool.nl/?p=910

[Anonymous]

Logically I still doubt honestly due to following

A executive is assigned to Lead

That executive my not be calling the lead

Calls table is linked to leads and executive

thus what data will the merged table hold(Say I merge Leads and Calls) ?

Which Executive id to hold? the assigned or the calling?

I think Duplicating Entire Tables seems the only answer.

[Anonymous]

Can u also let me what do u mean by to use Set Analysis once data is duplicated?

[MayilVahanan]

HI

ExecutiveId1 has value 1,2,3 in executive table.

ExecutiveId1 has 1,2 in      Calls table

ExecutiveId has 1,2 in Lead table.

Qv automatically join by names, so ExecutiveId1 join executive table n calls table.

LeadId1 join the Lead n Calls table because of same name in both of it..

So it avoid the synthetic key as well as loop structure by renaming the field.

Hope you can understand it..

[CELAMBARASAN]

Hi Mayil,

What happens there is no call made between the one particular lead and executive?

Hi Saurabh Pandit

Is there a chance of no call between lead and executive?

[Anonymous]

Yes. That is possible. I am also using Table box and trying to find a solution.