7 days rolling average in a KPI

[abc_18]

Hello everyone,

I have to show rolling 7 days sales data vs 7 days earlier sales data in a KPI.

for ex:-

Like if today is 20th,  then 1st KPI should give Avg Sales of 13th to 19th and second KPI should be Avg Sales of 6th to 12th.

I tried using rangeavg  and rangesum, but in KPI it's not working,  please suggest.

[Dalton_Ruer · Accepted solution]

You are looking for Set Analysis here is post that has just what you are looking for.

https://community.qlik.com/t5/QlikView-App-Dev/How-to-get-last-week-value-in-set-analysis/td-p/89063

[abc_18]

Hi Dalton,

Thanks for the suggestion, got the required output with the help of above post provided by you.

Regards