Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Period comparison for selected MonthAndYear

Hey,

i have been browsing this community for ages but could not find a solution for my problem. Even though there is a lot of input on the topic nothing helped.

I would like to compare the Sales for a selected period of time (MonthAndYear) with the same period 12 month ago. My best result is this one:

Sum({$<CalendarYear={$(=max(CalendarYear)-1)}>} Menge)

With this scenario I have to select years and month in seperate Listboxes, thus selecting only 'Jan 2011' AND 'Dez 2010' is not possible (at least i dont know how)

I would like to have the solution based on my selection in the field CalendarMonthAndYear.

Could my Calender Format be the problem? Right now I use this one (Found it somewhere in the net)

0 Replies