topic Cleaning up the data_model in QlikView https://community.qlik.com/t5/QlikView/Cleaning-up-the-data-model/m-p/432401#M696173 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am just trying to do some cleaning_up in the data_model of my current document, and parallely we are trying to do the same in a document on the middle_tier of our three-tier QV architecture.</P><P>I am a bit uncertain here about the order in which QlikView-script executes certain operations: Say I want to successively join tables - from the outside in, so to speak - in a data model. That means I have to actually join the two "outer" tables first and then join the resulting table to the "inner" one. How could I influence the execution_order to achieve that?</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Tue, 07 May 2013 07:48:45 GMT datanibbler 2013-05-07T07:48:45Z Cleaning up the data_model https://community.qlik.com/t5/QlikView/Cleaning-up-the-data-model/m-p/432401#M696173 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am just trying to do some cleaning_up in the data_model of my current document, and parallely we are trying to do the same in a document on the middle_tier of our three-tier QV architecture.</P><P>I am a bit uncertain here about the order in which QlikView-script executes certain operations: Say I want to successively join tables - from the outside in, so to speak - in a data model. That means I have to actually join the two "outer" tables first and then join the resulting table to the "inner" one. How could I influence the execution_order to achieve that?</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Tue, 07 May 2013 07:48:45 GMT https://community.qlik.com/t5/QlikView/Cleaning-up-the-data-model/m-p/432401#M696173 datanibbler 2013-05-07T07:48:45Z Re: Cleaning up the data_model https://community.qlik.com/t5/QlikView/Cleaning-up-the-data-model/m-p/432402#M696174 <HTML><HEAD></HEAD><BODY><P>There is another issue with my data model: I now have something like the ideal "star schema" - a fact table and two dimension (masterdata) tables connected to it - but there is a second fact table, but it has only one field in common with the first, and I have by now realized that the issue of a keyfield being unique ("Perfect key") or not ("Primary key" or just "key") does have an influence on things.</P><P>What can I do to deal with this issue (it does not currently cause any problems, so I'm not sure I even have to address it)?</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Tue, 07 May 2013 08:22:18 GMT https://community.qlik.com/t5/QlikView/Cleaning-up-the-data-model/m-p/432402#M696174 datanibbler 2013-05-07T08:22:18Z