7 Replies Latest reply: Aug 30, 2012 1:09 AM by Jean-Pierre Bakhache RSS

    Dimensionality and set analysis

      Hi friends,


      Please help me out in resolving this , I have the data as below in the raw data sheet and need the result as in the result image ,dont know how can that be done using set analysis and dimensionality in qlikview ,kindly help


      Raw data :


      Result :

      the amounts are identified in the ranges as 1 and are finally the amounts are summed at the bottom of the range column and are displayed as below



      Kindly hlep me out how can this be possible

      sample excel sheet is attached herewith for input source


      Kind Regards