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 :

      1.jpg

      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

      2.jpg

       

      Kindly hlep me out how can this be possible

      sample excel sheet is attached herewith for input source

       

      Kind Regards

      Anand