Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i would like to calculate KPI as below. first row is rolling 12 months, and for 3 KPI , CY sales and LY sales,and %.
can anybody help? Thanks.
Hi,
Please have a look on it.
https://community.qlik.com/t5/QlikView-Documents/Set-Analysis-for-Rolling-Periods/ta-p/1496283
Thanks Chanty4u
i have tried before for the set analysis expression. the current sales is ok. however, when i would like to show last year's sales, data will be appeared in the last year's year month. eg. i would like to show ly for same period 202010, the ly data show in 201910 column and the cy vs ly % also have the same problem.
i have tried set key field one by one, however, the KPI for rolling 12 months is up to 300.
Please advise and help.