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
Hi Avinash,
like this ?
Please check if the attached file serves the purpose
Sorry Missed the attachment
Yes Antonio,but each date may have multiple values.
Please share
I have attached the file is there any issues accessing it.
What is the expected result ?
Plz see the attached file.
Actually I cant access the qvw file inside qlik sense.