Rolling 12 month calculation

[GraceGao]

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.

[Chanty4u]

Hi,

Please have a look on it.

https://community.qlik.com/t5/QlikView-Documents/Set-Analysis-for-Rolling-Periods/ta-p/1496283

[GraceGao]

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.