Rolling 5 days sum

[Anonymous]

I have a date field and I want the sum of value for past 5 days for each day in a rolling fashion.each date has multiple values.

I tried using  sum({1<DATE = {">=$(=(Only(CdDate)-5)) <$(=Only(CdDate))"}>}[value])

but so far no luck.Please help

[antoniotiman]

See Attachment.

[Anonymous]

Would you please share your expression since qvw file is not accessible in Qlik sense

[antoniotiman]

See Attachment