topic Re: NPrinting Previous Year Month in Qlik NPrinting

NPrinting Previous Year Month

profilejamesbond — Wed, 18 Jan 2023 10:17:02 GMT

Hi,

I want to show the data of Previous Month Year "December 2022" in the NPrinting Report.

How to achieve it? Do I need to create Filter with Date field?

NPrinting > Filters

Field Name: %Date

Values: Monthstart(addmonths(today(), -1))

Re: NPrinting Previous Year Month

Lech_Miszkiewicz — Wed, 18 Jan 2023 11:16:29 GMT

Please upgrade version of Nprinting to supported version. Yours 17.0 does not allow for dynamic filters and using currently supported version will allow you to use advanced filter option or evaluate value.

question is-how would you apply this selection in Qlik Sense? Once you answer that question then you can create the same filter in Nprinting.

make sure you check below link and read in details topics about filters. Pay special attention to parts where i mention importance of datatypes used as it will drive decision on how your nprinting filter will have to be created.

more about filters on my blog: https://nprintingadventures.com

Re: NPrinting Previous Year Month

profilejamesbond — Wed, 18 Jan 2023 12:28:49 GMT

To tell you the truth, I don't know the version.

But I see it supports to evaluate.

Re: NPrinting Previous Year Month

Lech_Miszkiewicz — Wed, 18 Jan 2023 13:02:28 GMT

You can check the version when you log in to nprinting console under “about” menu

Re: NPrinting Previous Year Month

Frank_S — Wed, 18 Jan 2023 16:49:44 GMT

Hi @profilejamesbond

If you are using a supported version of NPrinting, I suggest you test your expressions in a Qlik Sense text box or other chart object using the expression editor tools therein.

Your formula as written

Monthstart(addmonths(today(), -1))

will not work for Qlik Sense and therefore not work for NPrinting since the syntax is not valid

I've tested this successfully.

monthstart(addmonths(today() ,1))

For details visit

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/addmonths.htm#anchor-1

Kind regards...

Re: NPrinting Previous Year Month

profilejamesbond — Thu, 19 Jan 2023 14:20:19 GMT

Thank you @Frank_S.

Thank you @Lech_Miszkiewicz

I have acheived the task same way.

The field was in text format therefore I used text keyword to convert it in NPrinting Filter section:

Name = MonthYear

Value =Text(MonthName(AddMonths(Today(), -1)))