Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please Help for sum by specific dimension / AGGR function

Hello i try in a simple table with 2 dimensions (Tiers comptable (Customer) ans Numpiece (NumOrder) and the expression below :

=If(Today()-[D_ENTET.Date d'échéance de la pièce]>=0,sum({$<[D_ENTET.Module d'origine] = {"2 - Comptabilité"},[D_COMPTECPTA.Compte cumul 2] = {41},NumPiece =>} [F_COMPTABLE2.Solde (D-C) en devise société]),0)

In a simple tab, i can display the total automaticaly with option graphic object.

i would like to make a sum of my expression by only dimension Tiers comptable (Customer) but it doesn't work !!!

I try with AGGR function but the result it's not OK. I want to display the sum of lines whith are ok in my test if today...

I would like to obtain the result 352274,4 for the customer 0002076145 but with a sum or aggr function in my expression.

Please see the attachement for concrete example.

0 Replies