NPrinting 17 Set Field Filter

[Anonymous]

Hey Guys,

Im following on from some recent help regarding a filter value that needs to be set to TODAY-2 Days on the Date field. Is anyone perhaps able to assist with what this issue that I am current facing which is causing my reload task to fail in N17.

I have attached the images below, the first image below is exactly how its used within the Qlik model. The second and third images are how they are setup in NPrinting 17 along with the error that we are getting (N17 April Release).

Its the only issue causing my reloads to fail and I cannot seem to pinpoint why. The country/land filter alone works just fine, however this fails when I combine it with my date filter that I created.

Thanks In Advance

[Lech_Miszkiewicz]

Hi Justin

I think there is just one missing step - data type. As you know Qlik has this ability to store recordes as numbers, dates, text, dual value(mix of text and number) etc.. In Qlik it all somehow work. Now when we go to NPrinting we have to be explicit.

In your case your date field is likely to be integer,date column so in your nprinitng filter you would need to use num(Today()-2).

Also make sure that your date field in Qlik is not having a timestamp so just maybe run Floor() function on it when doing reload?

cheers

Lech

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

[Anonymous]

Hey Lech,

Iv done a floor() function on the date column just to ensure everything is in order. Im still confused as to why NPrinting 17 wont accept this evaluated option. I ran a test with a button on Qlikview and that would not let me apply the num(Today()-2) function to select my date but it will allow me to use date(Today()-2). So I presume NPrinting 17 also then wont accept the num(Today()-2) function either if this is the case?

Iv also tried setting the value as all 3 options in NPrinting (Set Value, Set Numeric, Set Evaluated) to but all still popup with the same warning message. The latest attempt dont immediately fail however they do not send the email with the report and just pop a warning message (baby step progress )

[Lech_Miszkiewicz]

well - did you actualy try to do =num(Today()-2) in NPrinting?

i understand that it could not work in QlikView, but NPrinting is different story...

regards

Lech

[Anonymous · Accepted solution]

Hey Lech,

Came right with some direction from cn_sa_dev‌ and your answer. The final solution was as follows:

1. Used our common calendar that contains our date field
2. Created an addition column in this calendar called DateNum which was created with the following logic from your suggestion
   1. Num(Date) as DateNum

     3. Set the field within NPrinting 17 to evaluate and used the new Num value, floor'd it just incase.\

     4. Task then ran successfully

Thanks again for the guidance leading up to this task and to cn_sa_dev‌ for the help in the execution.

[Anonymous]

Yep that was attempted, did all 3 options with num. Posted the solution below, thanks for getting me in the right direction

[Lech_Miszkiewicz]

good on ya - cheers !