Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Please Help for sum in object text

I try to build an indicator (sum) of the formula below :

=sum(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))

There is no pb when the formula is in the tab with dimensions [NumPiece] and Customer (Tiers)  but i would like agregate the data by customer, like the TOTAL in the tab of the screenshot in the attachement.

how to obtain the result 352274,4 in a variable or in a text object ? This result is the agregation of the details.

When i make a SUM, it doesnt work !!! Please thank you by advance for your help.



Community Browser