topic cross fact table anaylsis in QlikView https://community.qlik.com/t5/QlikView/cross-fact-table-anaylsis/m-p/1088097#M465981 <HTML><HEAD></HEAD><BODY><P>Guys, currently I have recreated a link table for all of my fact tables so that perform analysis by either time or staff information. However, now I encounter another issue. If I want to perform analysis across 2 fact tables, I just can't.</P><P></P><P>For example, data in MDM_REG is about users using our mobile solutions, and data in APP_install is about our self-develop APPs usage. If I want to check how many users who have install a specific APP, and also running iOS 9.2, I can't sort that out in the Link Table.</P><P></P><P>Is there any way I can do, but also without circular reference? Thank you very much<IMG alt="DataModel.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115568_DataModel.png" style="height: 342px; width: 620px;" /></P></BODY></HTML> Tue, 23 Feb 2016 03:26:10 GMT 2016-02-23T03:26:10Z cross fact table anaylsis https://community.qlik.com/t5/QlikView/cross-fact-table-anaylsis/m-p/1088097#M465981 <HTML><HEAD></HEAD><BODY><P>Guys, currently I have recreated a link table for all of my fact tables so that perform analysis by either time or staff information. However, now I encounter another issue. If I want to perform analysis across 2 fact tables, I just can't.</P><P></P><P>For example, data in MDM_REG is about users using our mobile solutions, and data in APP_install is about our self-develop APPs usage. If I want to check how many users who have install a specific APP, and also running iOS 9.2, I can't sort that out in the Link Table.</P><P></P><P>Is there any way I can do, but also without circular reference? Thank you very much<IMG alt="DataModel.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115568_DataModel.png" style="height: 342px; width: 620px;" /></P></BODY></HTML> Tue, 23 Feb 2016 03:26:10 GMT https://community.qlik.com/t5/QlikView/cross-fact-table-anaylsis/m-p/1088097#M465981 2016-02-23T03:26:10Z