topic Re: Page feature issues in Qlik NPrinting

Page feature issues

QlikBeginner1 — Tue, 14 Jan 2020 11:12:25 GMT

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!!

Re: Page feature issues

Ruggero_Piccoli — Tue, 14 Jan 2020 13:15:29 GMT

Hi,

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

Best Regards,

Ruggero

Re: Page feature issues

QlikBeginner1 — Tue, 14 Jan 2020 15:46:47 GMT

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

Re: Page feature issues

Lech_Miszkiewicz — Tue, 14 Jan 2020 23:29:33 GMT

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-dynamic-filters.htm#anchor-9

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 .

Re: Page feature issues

Ruggero_Piccoli — Wed, 15 Jan 2020 14:56:52 GMT

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

Re: Page feature issues

QlikBeginner1 — Thu, 16 Jan 2020 10:16:22 GMT

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