This content has been marked as final. Show 4 replies
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 :
witch is made like this :
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