3 Replies Latest reply: Feb 12, 2015 8:23 AM by Priya R RSS

    AGGR

    Priya R

      Hi Experts,

       

      below is my requirement and example as atacehed(Ex)

       

       

      display first Crisp name to avoid duplicates for unique combination (PARENT + CSA)"

       

       

       

       

       

       

       

       

      And I have attached Ead dashboard which is current one.

       

       

      Thanks you,

      Priya

        • Re: AGGR

          Hi Priya,

           

          your aggr expression should be something like this

           

          aggr(sum(P1),CSA ID,PARENT ID) and in the chart you should not include dimension as CRISP Parent full name.

           

          if you still want it to happen even after adding CRISP name then you need to look in purgechar keep char functions and get the names same.

            • Re: AGGR
              Priya R

              Hi Deepak,,

              Could you please elaborate, if you don't mind

               

              Expression - sum(EAD)

               

              Ex

               

              here its not the case. We need to group the data by CSAID and PARENT(Dimensions)

               

              Total Dimensions in my pivot table/data like below

               

              CrispName      Parent      CSAID   Period:  P0   P1   P2   P3

              Citi Bank N    Citi            0                        100 10    20    3

              Citi Bank PP  Citi            0                          2    3     5    8

              Citi Bank TT   Citi            5                         1     10    55  88

               

              Result like:

               

               

              CrispName      Parent      CSAID   Period:    P0     P1   P2   P3

              Citi Bank N    Citi            0                        102     13    25   11

              Citi Bank TT   Citi            5                         1       10    55  88

               

               

              Here Parent and CSAID should be unique.

            • Re: AGGR
              Priya R

              Ruben has answered for this, you can check it on below link

               

               

              http://community.qlik.com/message/712595#712595