4 Replies Latest reply: Dec 7, 2013 11:51 PM by Learn Qlikview RSS

    Intersection / Set analysis

      I need some help with the following: My goal is to find clients who bought Cat1 product also bought Cat2 products.

       

      1. I have the data in one table as give below:

       

      Prod CatProd Sub CatClient AddMySalesTeamSales
      Cat1Prod1Client1100100
      Cat1Other ProductsClient10200
      Cat2Prod3ClentX100100
      Cat2Other ProductsClient10400
      Cat2Prod4Client150100

       

      I need a output as the followng :

       

      After selecting Cat1, I need to show only the following record. Any suggestions?

       

      Cat2Client150500

       

       

      thanks !