Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression Editor- Sum where date >=

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

Labels (1)
11 Replies
sunny_talwar

Try this

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


Capture.PNG

Anonymous
Not applicable
Author

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