Qlik Sense: Show all Data until selected Month (Charts, KPI,..)

[surtex]

Hello Member,

I would like to show all Data until the month which I have selected.

For Example: I select Juli 2022 in my filter, so i would like to show the data from Jan 2022 to Juli 2022. 

On the one site I will show data in a bar char and on the other hand i have a KPI, where I would like to show YTD (Year to date).

Just now my expression is:

Sum({<Profit_Center_COPA = {'185', '186', '187', '188', '189', '152'}, Year = {'2022'}>}"EBIT adjusted")/1000 

I take a filter where always one month is selected. How can I incorporate this into the formula above?

The "EBIT adjusted" datas have a connection to Dimension calender with the field YearMonth: 202207 

Thanks a lot 🙂 

[martinpohl]

the Year has to be calculated, so

Year={'$(=Year(today()))'}

Regards

[BrunPierre · Accepted solution]

Maybe this

Year ={"$(=Year(Today()))"}