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.

       

      ExpressionIssue.PNG

       

      Any help is greatly appreciated.