Set analysis expression is not working

[deep2021]

Hi,

My below expression based on date difference is not working. Could you please assist me.

Sum( {<test_date={">=$(=Date(min(date(test_date))-(Interval(max(Date(test_date)+7)-min(Date(test_date)),'d'))))<=$(=Date(max(date(test_date))-(Interval(max(Date(test_date)+7)-min(Date(test_date)),'d'))))"}>}sales)

Thanks

Thanks.

[vinieme12 · Accepted solution]

Try below; you can add days to a date directly,

Sum( {<test_date={">=$(=Date( min(test_date)-(( max(test_date)+7)-min(test_date)) )) <= $(=Date(max(test_date)-( (max(test_date)+7)-min(test_date)) ))"} >}sales)

[deep2021]

This is showing right results in the KPI object but not in the table. In table it is still showing current dates. Could you please assist me

[vinieme12]

can you post an app with some dummy data?