4 Replies Latest reply: Jul 6, 2018 3:55 AM by Olivier GAUTIER RSS

    Compare Own Company Sales with Other Company

    vikas mahajan

      Hi all,

       

      I have following data set like  Company , Product , Customer and his area  , my requirement is when user will see 2 charts

      own company sale vs Other Company Sale with Area will be common between this 2 charts

       

      CompanyProductSalesMonthYearCustomerArea
      AMS25000201804C1Mumbai
      AHS35000201804C1Mumbai
      BMS55000201804C2Thane
      BHS65000201804C2Thane
      CMS24000201804C3Raigad
      CHS35000201804C3Raigad
      AMS24800201805C1Mumbai
      AHS34800201805C1Mumbai
      BMS54800201805C2Thane
      BHS64800201805C2Thane
      CMS23800201805C3Raigad
      CHS34800201805C3Raigad

       

       

      Requirement is like this :

       

         

      Period  : 201804
      Own Company Sales Analysis
      CompanyProductAreaSale
      AMSMumbai25000
      AHSThane35000
      Other Company Sales Analysis
      CompanyProductAreaSale
      BMSMumbai55000
      BHSThane65000
      CMSMumbai24000
      CHSThane35000

        How to achieve the same in Qlik sense ?

       

       

      Regards

       

      Vikas