topic Re: last working date in Qlik NPrinting

last working date

nouha — Wed, 24 May 2023 09:50:20 GMT

i want to get data for the last working date

when i try today()-1 it give me the last day but i want the last working date

thank you

Re: last working date

Lech_Miszkiewicz — Wed, 24 May 2023 10:00:07 GMT

You need to work on that in your Qlik Calendar. Different countries have different public holidays/working days. During load script you can create a flag for working days and then you can use advanced search filter for that

cheers

More about advanced filters :https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

by the way - your version 16 of NPrinting is not supported. You need to migrate to supported NPrinting.

Re: last working date

nouha — Wed, 24 May 2023 10:12:20 GMT

thank you

did you mean i create the flag in qlik sense because i m new in nprintig and qliksense

in qliksense i have the working day and in qliknprinting i am usine the advenced seacr for last 7 days

and the version of nprinting i am working in a societe it s not for my own project

Re: last working date

Lech_Miszkiewicz — Wed, 24 May 2023 11:03:46 GMT

Hi @nouha

If you are new to Qlik Sense and NPrinting then welcome. I will encourage you to study and get proper training before doing anything in NPrinting. good start is on https://help.qlik.com where you will find resources for Qlik Sense and NPrinting. Back to this topic:

version of NPrinting - you have indicated in your label version "NPrinting 16" - Pay attention to this when youu create post. Clearly NPrinting 16 is out of support and also does not work with Qlik Sense. It is important to keep housekeeping clean and stop causing those kind of errors. Also let us know the version of software you are using as our answers can change based on that!!!
In regards to a flag - there are many options.
1. I would create a flag in Qlik Sense load script so it indicates date which is your last working date. Then in NPrinting you can just apply filter on that flag. That would be best practice.
2. Alternative is advance search or evaluate value and then it would be to get a date which would meet 2 criteria:
  1. < Today
  2. and Max date with "working day" flag
  3. syntax would be similar to this: =max({<WorkingDayFlag={1},YourDateField={"<$(=Today())"}>}YourDateField)

I suggest you focus first on making things right in Qlik Sense. Make sure you study links I have given you, also make sure you understand data types of dates and issues they may create. I wrote about this in those topics:

Re: last working date

nouha — Wed, 24 May 2023 12:31:48 GMT

really thank you very much for your details i will check and come back to you thanks

Re: last working date

nouha — Wed, 24 May 2023 12:38:18 GMT

i am using nprinting 19.40.3.0

Re: last working date

Ruggero_Piccoli — Thu, 25 May 2023 09:31:04 GMT

Hi,

Please pay attention to adding the correct label and note that also 19.40.3 (November 2019) is out of support so upgrade to a supported version as soon as possible.

Best Regards,

Ruggero