Create "Year-to-date" KPI

[RubenMoreno]

Hello,

I created a Measure in Qlik Sense and I am displaying its value on a weekly basis (please refer to the red line in the picture attached).

Additionally, I would like now to create a "year-to-date" KPI displaying the average of the weekly value of the Measure from beginning of the year till today. May I ask for support on how to create the new Measure/KPI?

Thank you in advance.

Best regards,
Rubén  

[Wlad_Masi]

@RubenMoreno  would Set Analysis resolve your problem?

Something like Avg({<Date>{'01/01/2020'}>}value)
This post also talks about this topic.

[usamabinsadiq · Accepted solution]

Hi,

You can use this:

avg({<YEAR={$(=max(YEAR))}>} YOUR_MEASURE_NAME)

and if Year is not generated with load script then you can use following

avg({<Year(YourDateFeld)={$(=max(Year(YourDateFied)))}>} YOUR_MEASURE_NAME)

I hope this helps,

Regards, 

[usamabinsadiq]

if my replay helped you then please do not forget to use the "Accept as Solution" button.