topic Re: What is the Answer ? in QlikView https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812531#M659950 <HTML><HEAD></HEAD><BODY><P>many to many.</P><P></P><P>cartesian....</P></BODY></HTML> Fri, 27 Mar 2015 23:09:55 GMT Anonymous 2015-03-27T23:09:55Z What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812529#M659948 <HTML><HEAD></HEAD><BODY><P>Following is the interview question, which is posed by the interviewer in the recent interview.Would like to know the answer for this. </P><P>And also come content on these kind of questions. </P><P></P><OL style="list-style-type: decimal;"><LI> There is a schema given, table A to C is one to many and B to C is one to many. What is the relation between A and B<OL style="list-style-type: lower-alpha;"><LI>a. One to many</LI><LI>b. Many to many</LI><LI>c. Many to one</LI></OL></LI></OL><P></P><P>Regards,</P><P>Alvin. </P></BODY></HTML> Fri, 27 Mar 2015 22:24:11 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812529#M659948 alvinford 2015-03-27T22:24:11Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812530#M659949 <HTML><HEAD></HEAD><BODY><P>many to many</P></BODY></HTML> Fri, 27 Mar 2015 22:56:31 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812530#M659949 robert_mika 2015-03-27T22:56:31Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812531#M659950 <HTML><HEAD></HEAD><BODY><P>many to many.</P><P></P><P>cartesian....</P></BODY></HTML> Fri, 27 Mar 2015 23:09:55 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812531#M659950 Anonymous 2015-03-27T23:09:55Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812532#M659951 <HTML><HEAD></HEAD><BODY><P>Personally think it's a bad question for a QV Developer but this image illustrates the answer.</P><P></P><P>Orders can have many Products and Products can have many orders.&nbsp; So this is a many to many relationship.</P><P></P><P><IMG alt="manymany-links-lg.gif" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82196_manymany-links-lg.gif" style="height: 181px; width: 620px;" /></P></BODY></HTML> Sat, 28 Mar 2015 03:48:33 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812532#M659951 Anonymous 2015-03-28T03:48:33Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812533#M659952 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think , answer is many to many .</P></BODY></HTML> Sat, 28 Mar 2015 06:52:18 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812533#M659952 2015-03-28T06:52:18Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812534#M659953 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Many to many</P></BODY></HTML> Sat, 28 Mar 2015 07:03:05 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812534#M659953 mukesh24 2015-03-28T07:03:05Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812535#M659954 <HTML><HEAD></HEAD><BODY><P>many to many</P></BODY></HTML> Sat, 28 Mar 2015 11:00:50 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812535#M659954 2015-03-28T11:00:50Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812536#M659955 <HTML><HEAD></HEAD><BODY><P>... unless it is being posed a trick question, as depending on the data and whether the key fields are unique or not it could be any of the three answers.</P></BODY></HTML> Sat, 28 Mar 2015 11:09:58 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812536#M659955 Anonymous 2015-03-28T11:09:58Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812537#M659956 <HTML><HEAD></HEAD><BODY><P>That was what I initially thought as well.&nbsp; Unless Table C is defined as a Junction Table it does seem it could be any of the answers.</P></BODY></HTML> Sat, 28 Mar 2015 14:02:55 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812537#M659956 Anonymous 2015-03-28T14:02:55Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812538#M659957 <HTML><HEAD></HEAD><BODY><P>Depends on how Table C is joining table between A an B... General Scenario it is Many to Many but as Bill said, it could be any answer...</P></BODY></HTML> Sat, 28 Mar 2015 14:20:35 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812538#M659957 MK_QSL 2015-03-28T14:20:35Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812539#M659958 <HTML><HEAD></HEAD><BODY><P>many to many</P></BODY></HTML> Fri, 21 Aug 2015 15:04:18 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812539#M659958 2015-08-21T15:04:18Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812540#M659959 <HTML><HEAD></HEAD><BODY><P>It is no doubt about it: many-to-many.</P><P></P><P>This does not depend on the actual values - because the question itself states the relationship between the tables A,C and B,C and pure logic tells us the missing piece.</P><P></P><P>The question is posed like this is an Entity-Relationship modeling thing. QlikView use associations and does not have relationships as such - although they have many similarities.</P></BODY></HTML> Mon, 24 Aug 2015 06:09:58 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812540#M659959 petter 2015-08-24T06:09:58Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812541#M659960 <HTML><HEAD></HEAD><BODY><P>Its many to many </P><P>Becoz Both the tables have B field so there would be the relationship in between all the fields.</P><P></P><P>Regards </P><P>Amarnath</P></BODY></HTML> Mon, 24 Aug 2015 07:03:19 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812541#M659960 prajapatiamar38 2015-08-24T07:03:19Z Re: What is the Answer ? https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812542#M659961 <HTML><HEAD></HEAD><BODY><P>many to many.</P><P></P><P>any doubt?</P></BODY></HTML> Sun, 06 Sep 2015 11:10:24 GMT https://community.qlik.com/t5/QlikView/What-is-the-Answer/m-p/812542#M659961 Anonymous 2015-09-06T11:10:24Z