Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
giovanneb
Creator II
Creator II

Set Analysis to present data from the previous month when the filtered dimension this year as the current selection

Hello I have the following situation:

used the following set Analysis:

sum ({$} <Month_Sale = {$(=month(addmonths(max(Date_Sale), -1)))}> Qty)

By using the expression above it works correctly when the selection year is exergar filter to the data of the previous month, my problem happens when I select the month of January because this expression brings zeroed data, how can I resolve this situation? thank you

10 Replies
giovanneb
Creator II
Creator II
Author

Hi, perfect solution, thanks