Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

engr_farhanqadr
New Contributor II

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

Tags (1)
1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

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

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

3 Replies
lironbaram
Honored Contributor II

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

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

engr_farhanqadr
New Contributor II

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

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.

lironbaram
Honored Contributor II

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

hi

the best way for you

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

monthstart(date) as Month

Community Browser