Page feature issues

[QlikBeginner1]

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]

Hi,

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

Best Regards,

Ruggero

[QlikBeginner1]

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]

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 .

[Ruggero_Piccoli]

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

[QlikBeginner1]

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