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

    Intersection / Set analysis

    Learn Qlikview

      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
      Cat1Other ProductsClient10200
      Cat2Other ProductsClient10400


      I need a output as the followng :


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





      thanks !