Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi Dalton,
Thanks for the suggestion, got the required output with the help of above post provided by you.
Regards