App Development

[miguelcunha]

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]

Is there only One Open_Date? May be this

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

or

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

[miguelcunha]

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

I tryed both your answers and it didn't work

[sunny_talwar]

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

[miguelcunha]

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

[sunny_talwar]

Mocked up data which resembles the original scenario?

[miguelcunha]

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?

[miguelcunha]

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

shared a document, can you open it?

[sunny_talwar]

Would you be able to attach something here?

Uploading a Sample

[miguelcunha]

here it is!