2 Replies Latest reply: Apr 13, 2016 12:38 PM by Fabio Ramirez RSS

    Sales vs Goals in QlikView

    Fabio Ramirez

      Dear, good afternoon

      I have a small problem with QlikView, it is about putting some goals in an application. I mention the following:

      I have two tables one where the sales and another where the goals, should make a cross so that I consider to all products that have not had sales but if they have a goal and vice versa. Everything is displayed in a table.

       

       

      Try with an outer join and if I run but the subject of sales have like 8 million records and to make the crossing is slow recontra. You will have no alternative to working with porsiacaso goals. I enclose the file. Thanks for your support.

       

      Attachment