Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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