Sum of Fees

[SimonY13]

Hi, 

I am looking to produce a table that shows us the value of fees we have added to the system each day. I am using the below expression...

Sum({$<[Date Type]={'Fee Date'}>}[Fee Amount])*DateFlag_MTD 

The chart has Date as the dimension, the problem I am getting is it is not summing correctly and the totals are always higher than they should be..

I have created a second chart that lists the fees on a specific day using the below expression 

[Fee Date]='11/08/2020'

This table is correct and shows all the fees entered on the 11th August which total 14k yet the first table show £15300k, any ideas?

Thanks in advance

Simon

[Brett_Bleess]

Without the QVW in this case, you are unlikely to get responses, as with these types of post, folks generally need to be able to see the data model in the QVW file and the objects and expressions in order to try to determine what you have done wrong.

The best I can do otherwise are the following links:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

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

Regards,
Brett