Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

how to apply filter on another sheet in excel template in nprinting

Hi Folks,

I am stuck in problem I have a report of branches . I need to show each month report on each excel sheet through Nprinting. I have date filed how can I apply each field value on each sheet.

Thanks

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

hi

it's actually fairly easy

use the Date field as a page in the excel template

and it'll automatically creates a sheet per value in the date field

View solution in original post

3 Replies
Highlighted
Partner
Partner

hi

it's actually fairly easy

use the Date field as a page in the excel template

and it'll automatically creates a sheet per value in the date field

View solution in original post

Highlighted
Creator
Creator

thanks for the answer one more thing. In that date field I have different values I only want year 2016 month end in that list box.

I wrote   '=if( Year([CURRENT_DATE.Current Date])='2016',MonthEnd([CURRENT_DATE.Current Date]))'  in formula but it is not working.

Highlighted
Partner
Partner

hi

the best way for you

will be to create month field in the script with this expression

monthstart(date) as Month