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]

Hi Avinash,

like this ?

[anushree1]

Please check if the attached file serves the purpose

[anushree1]

Sorry Missed the attachment

[Anonymous]

Yes Antonio,but each date may have multiple values.

[Anonymous]

Please share

[anushree1]

I have attached the file is there any issues accessing it.

[antoniotiman]

What is the expected result ?

[Anonymous]

Plz see the attached file.

[Anonymous]

Actually I cant access the qvw file inside qlik sense.