4 Replies Latest reply: May 12, 2017 5:19 PM by Lech Miszkiewicz RSS

    Can't evaluate variable in NPrinting

    Justin Dallas

      Hello Everyone,


      I've got some header text that I would like to include in an NPrinting Excel report.  It looks something like this in my Data Load section of Qlik Sense.


      LET Today = timestamp(daystart(timestamp(today())) + maketime(6))
      LET Yesterday = timestamp(daystart(timestamp(today()-1)) + maketime(6))
      SET HeaderText = On-Time Exception Report for $(Yesterday) to $(Today)



      I've tried pretty much everything including creating a variable in NPrinting and I alway get this.


      Error: Garbage after expression: 'Exception'


      What can I do to make my header get calculated properly.




      Any help is greatly appreciated.