6 Replies Latest reply: Oct 15, 2018 11:05 AM by Dilip Ranjith RSS

    How to show data for previous month in Qlik Sense

    Yesenia Del Real

      Hi,

       

      I am trying to show only last month data.

      Example:

      Today's date is 10/11/18, which means we are in October. Because it is October, I want it to show me all the data records for the month of September.

       

      Currently my formula is only for the past 30 days, but this is not ideal since it takes in today's date and only subtracts 30.

      Count({< [Closed Date] = {"=[Closed Date] >= Today() - 30"} >} [Record ID])

       

       

      Thanks