Prakash Hinduja Switzerland (Swiss) How do I calculate variation in KPIs—comparing this period’s total to last year’s total in a KPI chart?

[prakashhindujageneva]

Hello Qlik Community,

I’m Prakash Hinduja, a consultant based in Geneva, Switzerland (Swiss), currently working on a KPI-driven dashboard for a client. I’m looking to display variation in KPIs—specifically, I want to compare this period’s total  to the same period last year in a clear and dynamic way using a KPI chart.

Regards

Prakash Hinduja Geneva, Switzerland (Swiss) 

[robert_mika]

Example:

This year

Sum({<DateField = {">=$(=Date(Today()-30))<=$(=Date(Today()))"}>} Sales)

Last year

Sum({<DateField = {">=$(=Date(AddYears(Today()-30,-1)))<=$(=Date(AddYears(Today(),-1))"}>} Sales)