4 Replies Latest reply: Oct 22, 2012 3:09 PM by gposner86 RSS

    Not sure if hierarchy

      I'm not sure if I should be using a hierarchy here or some other tool but I was hoping someone could help.  I have the following table setup in excel and want to find a way to organize this data in Qlikview

       

      Header 1Header 2Header 3Header 4Header 5Header 6
      ClientRevenueProductServiceCostExpectations
      ABC100x
      x
      EFG1500
      x

      LMNO300
      x
      x
      ZZZ250

      xx

       

      The four columns on the right are all choices a person would make.  I want to be able ot set up a table saying if a client has made a decision on Service, it will then show the total amount of money based on that criteria.  When I try to set anything up now it will not show the data being together, it will lable things as X and - (null).

       

      I'm not sure i'm explaining this properly but If anyone has any suggestions or needs more information it would be greatly appreciated.