1 Reply Latest reply: Feb 5, 2016 9:47 AM by Christiana Olschewski RSS

    NPrinting - Previous Quarter in Filter for Excel Reports

    Christiana Olschewski

      Hi,

       

      I'm trying to create an Excel report with NPrinting. This report should run once a quarter and always show the numbers of the previous quarter. How can I set up a filter in NPrinting so that the Excel report is showing only previous quarter figures?

      I do not want to use a the date selection in the Sales formula in Qlikview (e.g. sum({<CALENDER.DATE={">=$(=QuarterStart(num(QuarterStart(today()))-1))<=$(=QuarterEnd(num(QuarterStart(today()))-1))"}>} Sales) ), but I would like to filter in NPrinting.

      How could I do this?

       

      Many thanks for your help!