1 Reply Latest reply: Oct 29, 2015 4:22 AM by Gysbert Wassenaar RSS

    Calculating MTD values dynamically

    Shyam Chaware

      I am trying to build a MTD measure in QlikSense. The expression that I am using is –

       

      rangesum(above( sum({<MTD={'1'}>}[Attendee Amount]),0,rowno()))

       

      This does give the MTD numbers for the current month but in the sheet I have a drop down for months. If I choose any month other than the latest month I don’t get any values. Any ideas how I can make the expression dynamic?