7 Replies Latest reply: Jun 14, 2011 11:29 AM by CHRISTEREKBLAD RSS

    Set Analysis question

      Hi!

       

      I need help with a set analysis question. When I am selecting Supplier 1 in below example I want qlikview (in a graph) to summarize Sales for all categories that are related to Supplier 1 (see underlined Sales). Hence I want a column summarizing to 41 when I have selected Supplier 1.

       

      What is the expression for that? Prefferably in a SET Analysis expression.

       

      SupplierCategorySales
      1Shoes10
      1T-Shirts20
      2Balls25
      2Shoes5
      2Tennis15
      3Tennis3
      3T-Shirts6

       

      Best Regards

       

      Christer Ekblad