1 Reply Latest reply: Nov 18, 2014 3:57 AM by Nagaian Krishnamoorthy RSS

    Help regarding aggregation

    Raghav Kumar

      I have 2 columns. Based on data in column 1, I need to do a working on column 2.

       

      For example,

      1st row has District '1' with value as 200.

      I need to add another column which takes minimum of all the values against '1' and subtracts that from Value in the 1st row.

      In this case, Column 3 = 200 - min (all values against 1) = 200-100 = 100

       

      DistrictValueTo do in qlikview
      1200100B2-minimum of all values against 1.
      22000B3-minimum of all values against 2
      11000B4-minimum of all values against 1
      2300100
      1300200
      115050
      1400300

       

      Any help is very much appreciated.

       

      Regards

      Raghav