Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum(If(Date_last_y >= Open_Date, Sale_Value))
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