Expression Editor- Sum where date >=

[Anonymous]

Hey guys,

I'm trying to do the following sum:

SUM({<Date_last_y={">=$(Open_Date)"} >}Sale_Value)

Basically I want to sum Sale_Vaule where Data_last_y is greater or equal than Open_Date.

This is not working with my previously shown code.

Can you help me?

Thanks,

Miguel Cunha

[sunny_talwar · Accepted solution]

Try this

Sum(If(Date_last_y >= Open_Date, Sale_Value))

[Anonymous]

That's exacly it. Sometimes I feel like Expression Editor in Qlik Sense is not very precise and logic. Maybe I need more experience with it.

Thanks a lot for your help