4 Replies Latest reply: Aug 4, 2017 7:20 AM by Sunny Talwar RSS

    Problem with AGGR function

    Do espirito Arnault

      hi ,

       

      I have a problem with aggr function.

       

      (see attached qvw.)

       

      I have two tables :

      - one named PAIE with AMOUNT per COST_C/YEAR/MONTH/PERSO_ID/ACCOUNT

      - one named TAX with with TAXE_RATE per  YEAR/MONTH/PERSO_ID


      I have linked them in qlikview with a key (YEAR/MONTH/PERSO_ID) so every line of PAIE table has the good tax rate from TAX table.


      Know, i want to make a pivot table aggregated on COST_C for only ACCOUNT=32007.


      In excel, the result would be :


      excel.PNG

      witch is made like this :

      excel2.PNG

      I have tred to do that with set analysis and aggr function but it gives me a wrong result.

       

      Could you help me ?

       

      Thank you very much

       

      Arnault