Page feature issues

QlikBeginner1 · ‎2020-01-14

Hi,

I am building an NPrinting report, and using the 'Page' feature to split the data by year in separated sheets.

I have data from 2016- 2020. However, when I download the file from the news stand, NPrinting is creating sheets from dates going back from 1950. All these sheets are blank until 2014 where there is data.

How can I avoid this, to only create sheets where there is data?

Thanks in advance!!

Ruggero_Piccoli · ‎2020-01-14

Hi,

Create a filter that keeps only the years you want to see and apply it to the report.

Best Regards,

Ruggero

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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

QlikBeginner1 · ‎2020-01-14

Hi Ruggero,

Thanks for the response. Does this mean every year I will need to manually update the filter in the report to bring in the new years worth of data?

thanks

Lech_Miszkiewicz · ‎2020-01-14

no, you dont need to update it all the time

using advanced search filter you can use >= , or > or simply calculate x number of years based on some condition ( for example "year(today())-2". details in links below

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

https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/ReportsDevelopment/Static-dynam...

You could also clean up a data in your load script and keep only records in data model you need so there are no previous years .

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Ruggero_Piccoli · ‎2020-01-15

Hi,

I agree with @Lech_Miszkiewicz but please note that advanced search is supported starting from June 2019

Filter support QlikView and Qlik Sense Advanced Search
Qlik NPrinting filters support QlikView and Qlik Sense Advanced Search. You can create dynamic filters that, for example, keep values after a specified date; or text that contains a specific string and uses the same syntax of QlikView and Qlik Sense advanced search.

So, if you are using September 2018 as per your label, you first need to upgrade your installation to June 2019 or newer to use advanced search. I always suggest latest.

Best Regards,

Ruggero

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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

QlikBeginner1 · ‎2020-01-16

Thank you both for your input, this has helped me greatly! Appreciate the support!!

Qlik NPrinting September 2018

Qlik Sense