topic WHICH METHOD IS BEST ONE? in QlikView https://community.qlik.com/t5/QlikView/WHICH-METHOD-IS-BEST-ONE/m-p/657625#M1077644 <HTML><HEAD></HEAD><BODY><P>SUPPOSE IN MY PROJECT I HAVE 3 FACT TABLES . TH FACT TABLES JOIN INTO ONE FACT TABLE.SO WHICH ONE IS THE BEST ONE? IN QLIKVIEW IS THEIR ANY METHOD TO JOIN FACT TABLES OTHER THAN "JOIN" CONCEPTS?...&nbsp;&nbsp; </P></BODY></HTML> Fri, 11 Jul 2014 05:53:27 GMT 2014-07-11T05:53:27Z WHICH METHOD IS BEST ONE? https://community.qlik.com/t5/QlikView/WHICH-METHOD-IS-BEST-ONE/m-p/657625#M1077644 <HTML><HEAD></HEAD><BODY><P>SUPPOSE IN MY PROJECT I HAVE 3 FACT TABLES . TH FACT TABLES JOIN INTO ONE FACT TABLE.SO WHICH ONE IS THE BEST ONE? IN QLIKVIEW IS THEIR ANY METHOD TO JOIN FACT TABLES OTHER THAN "JOIN" CONCEPTS?...&nbsp;&nbsp; </P></BODY></HTML> Fri, 11 Jul 2014 05:53:27 GMT https://community.qlik.com/t5/QlikView/WHICH-METHOD-IS-BEST-ONE/m-p/657625#M1077644 2014-07-11T05:53:27Z Re: WHICH METHOD IS BEST ONE? https://community.qlik.com/t5/QlikView/WHICH-METHOD-IS-BEST-ONE/m-p/657626#M1077645 <HTML><HEAD></HEAD><BODY><P>Join the two fact table in qlikview we uses the Link tables method and link two fact tables to each other.</P></BODY></HTML> Fri, 11 Jul 2014 05:56:38 GMT https://community.qlik.com/t5/QlikView/WHICH-METHOD-IS-BEST-ONE/m-p/657626#M1077645 its_anandrjs 2014-07-11T05:56:38Z Re: WHICH METHOD IS BEST ONE? https://community.qlik.com/t5/QlikView/WHICH-METHOD-IS-BEST-ONE/m-p/657627#M1077646 <HTML><HEAD></HEAD><BODY><P>Yeah... Subbu; you can concate or you can user ApplyMap or Different joins (Left, right, inner, left keep, right keep); But still it all depend on the structure of your fact tables as well as the flow of data.</P><P></P><P>Find the attached image for reference. . .</P></BODY></HTML> Fri, 11 Jul 2014 05:57:25 GMT https://community.qlik.com/t5/QlikView/WHICH-METHOD-IS-BEST-ONE/m-p/657627#M1077646 brijesh1991 2014-07-11T05:57:25Z