9 Replies Latest reply: Jul 29, 2011 9:44 AM by Sunil Chauhan RSS

    New to QlikView - join problem

      I am currently evaluating QlikView.

       

      I have built a fairly simple demo application that extracts data from a 3rd party time management system and presents information about time spent on projects and supporting applications. I would like to show which projects have been undertaken for each application. Unfortunately I am working with a 3rd party database that does not provide a link between projects and applications.

       

      For the purpose of the demo application I thought I would create an Excel worksheet that linked each project to an application. However when I load this into QlikView I receive a warning about looping and advice that one of the tables will be loosely coupled which may cause unpredictable results.

       

      I do not understand why this is happening as the additional data is just a simple link table between 2 other tables in the schema.

       

      Any ideas how I can get round this?