Sum of Value for Date - 30

[danm84306]

Hello,

      I am looking for some Set Analysis help. I need to sum Dimension A only for dates that are the Max Date of Value B - 30 days. Nothing I am finding helps, any ideas?

something like

Sum({<Max(Date_B)-30>} Value_A)

[Anil_Babu_Samineni]

Just curious to know, Is there any diff b/w Mine and stalwar1‌ . To me only Date format is the problem. My answer is not helping for you?

Sunny's expression is this

Sum({<Date_B = {"$(=Date(Max(Date_B)-30, 'MM/DD/YYYY'))"}>} Value_A)

And mine is below

That's fine, You can look how we can close this thread - Qlik Community Tip: Marking Replies as Correct or Helpful