11 Replies Latest reply: Nov 20, 2017 2:05 PM by Russell Glenn RSS

    Current Month Revenue Display

    Russell Glenn

      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!