Current Month Revenue Display

[Anonymous]

Good morning everyone,

I have revenue data from two different months. When I go into my Qlik Sense sheet, my revenue formula sums the two months together until I choose a specific month with my filter pane. Is there a way I can write into the formula to automatically select the current month or max month when the revenue data is unselected?

I assume this can be done with a set modifier pointing to latest, current, or max month?

Thanks everyone!

[antoniotiman]

Try this

sum({<Month={"$(=MaxString(Date#(Month,'MMM')))"}>}Revenue)

[Anonymous]

Yes! This works…what is this doing? How does this assign which is must current? Our months are only assigned by Month names….like November, December etc…