Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Sum Current months vs same months but last year.

Hello dear Experts,

I am looking for an expression that allows me to calculate the sum of the sales of the months that have elapsed of the year vs. the same months but of the previous year. like this:
2020 Jan - Apr vs 2019 Jan - Apr.

For the Max year im using the next expression:
Sum({<[Year] = {$(=(Max(Year)))}>}Sales)

But I don't finish solving how to take the same months of the last selected year without having to enter them in a filter.

Someone did something like this before?

I really would appreciate any help.


0 Replies