Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Breaking Circular loop

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

20 Replies
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
Not applicable
Author

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
Not applicable
Author

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

You go with creating fact tables or link tables

for more information please read this article

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

Anonymous
Not applicable
Author

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
Not applicable
Author

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

export.png

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

Hope you can understand it..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

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
Not applicable
Author

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