2 Replies Latest reply: Sep 20, 2017 11:53 AM by Ruggero Piccoli RSS

    Filter for time in NPrinting

    Chris Attewell-Hughes

      Hi guys,

       

      I have a report which highlights errors throughout the day. I want it to show any errors within the last hour.

       

      I can get it to filter for errors in the logs, but not for the correct time stamp.

      The field it's pulling from is formatted 'DD/MM/YYYY HH:MM'.

      I'm using the below to filter the values using the "Evaluate Value" function in NPrinting:

       

      <=(now()-(1/24))


      When I add this time filter, I receive an empty Excel sheet.


      Does anyone have any ideas on how I can fix this?


      Chris A.

        • Re: Filter for time in NPrinting
          Matus Kelemen

          Hi Chris,

          what is the data type of the field?

          Check in the Document properties -> Tables.

          Btw last hour should be >=

          BR,

           

            Matus

          • Re: Filter for time in NPrinting
            Ruggero Piccoli

            In NPrinting 17 at the moment you cannot create a filter of kind "less then".

             

            My suggestion is:

            - create a QlikView or Qlik Sense table that contains only the rows that satisfy the condition (note that NPrinting supports hide tables if they are stored on visible sheet)

            - create a report that shows that table

            - add to the report a condition (Conditions ‒ Qlik NPrinting) that checks it that table as data and schedule the report periodically. When the schedule runs if the table has data, the report will be created if the table has no data no reports will be created.

             

             

            Best Regards,

            Ruggero

            ---------------------------------------------

            When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.