Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See Attachment.
Would you please share your expression since qvw file is not accessible in Qlik sense
See Attachment