10 Replies Latest reply: Oct 25, 2013 4:55 AM by Joe Berry RSS

    Nested Aggregation & Cumulation

      I have a dataset with two dimensions and one simple expression (count).

       

      I need to add an expression that is the total of the counts within one of the dimensions. So this is what I have, with Aggregate1 defined as

       

      Aggr(count(ID),Payband)

       

      PaybandMinimum BandsCount1Aggregate1
      < 1.54000004444
      1.5 - 2400000533215
      1.5 - 25000001451-
      1.5 - 2600000902-
      1.5 - 2750000470-
      1.5 - 21000000288-
      1.5 - 2150000051-

       

      What I need is two things. I need the 3215 to show for all of Payband, but then I also need to show the cumulative distribution as follows:

       

      1.5 - 240000053321598%
      1.5 - 25000001451321553%
      1.5 - 2600000902321525%
      1.5 - 2750000470321511%
      1.5 - 2100000028832152%
      1.5 - 215000005132150%

       

      Please please please can you let me know how to calculate these as expressions in qlikview.

       

      Thanks,

       

      Joe