topic Expression Editor- Sum where date >= in App Development

Expression Editor- Sum where date >=

Anonymous — Sat, 16 Nov 2024 08:55:41 GMT

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

Re: Expression Editor- Sum where date >=

sunny_talwar — Thu, 21 Dec 2017 17:18:59 GMT

Is there only One Open_Date? May be this

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

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

Re: Expression Editor- Sum where date >=

Anonymous — Thu, 21 Dec 2017 17:34:45 GMT

Open_Date is the store's opening day from my Stores Dimension

I tryed both your answers and it didn't work

Re: Expression Editor- Sum where date >=

sunny_talwar — Thu, 21 Dec 2017 17:50:37 GMT

I think you might need to use Aggr() function here... but difficult to say... would you be able to share a sample?

Re: Expression Editor- Sum where date >=

Anonymous — Thu, 21 Dec 2017 17:59:24 GMT

Unfortunately i cannot share a sample once this is my company data and confidencial information.

But basically I have a fact table with my sales like this:

Store_Code, Sales_Date,Sale_Value, Date_last_y

Date_last_y is the exact week day from the previous year.

Then I have my Store dimension with

Re: Expression Editor- Sum where date >=

sunny_talwar — Thu, 21 Dec 2017 18:00:12 GMT

Mocked up data which resembles the original scenario?

Re: Expression Editor- Sum where date >=

Anonymous — Thu, 21 Dec 2017 18:00:37 GMT

Unfortunately i cannot share a sample once this is my company data and confidencial information.

But basically I have a fact table with my sales like this:

Store_Code, Sales_Date,Sale_Value, Date_last_y

Date_last_y is the exact week day from the previous year.

Then I have my Store dimension with:
Store_code, Store_name, Company, Open_Date

Is this helpful?

Re: Expression Editor- Sum where date >=

Anonymous — Thu, 21 Dec 2017 18:13:38 GMT

https://pt.scribd.com/document/367691051/Qlik-Question

shared a document, can you open it?

Re: Expression Editor- Sum where date >=

sunny_talwar — Thu, 21 Dec 2017 18:14:34 GMT

Would you be able to attach something here?

Uploading a Sample

Re: Expression Editor- Sum where date >=

Anonymous — Thu, 21 Dec 2017 18:17:24 GMT

here it is!

Re: Expression Editor- Sum where date >=

sunny_talwar — Thu, 21 Dec 2017 18:25:23 GMT

Try this

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

Re: Expression Editor- Sum where date >=

Anonymous — Fri, 22 Dec 2017 09:51:07 GMT

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