Sum Expression Help

[ferdi_acari]

Hello,

My data is structured as below.

I want to show sum of customer balance on corresponding branch_id's start_date in a table's column.  Something like;

I tried the below expression but it didn't work as intended. It brings all zeros.

sum({<[Cust_Date]=[Start_Date]>}Balance)

Thank you, 🙂

[RafaelBarrios]

hi @ferdi_acari 

Try using possible value

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

Try sum({<[Cust_Date]=P([Start_Date])>}Balance)

OR join two of the three tables and create a composite key with Branch_ID and the date fields

Best,