topic Re: Nprinting Dynamic Filter based on field values in Qlik NPrinting

Nprinting Dynamic Filter based on field values

manoj2102 — Tue, 17 Mar 2020 20:40:38 GMT

Greeting.!

I want to send report via Nprinting based on schedule below.

So if today is Tuesday I need to send report to users for only data in my QS report for date of coming Thursday.

If today is Wednesday I need to send report to users for only data in my QS report for date of coming SAT,SUN,MON.

and so on as mentioned below in table.

Nprinting Schedule on	Mail to be sent for Date/ Day
Monday	Thursday
Tuesday	Friday
Wednesday	Saturday , Sunday , Monday
Thursday	Tuesday
Friday	Wednesday

Re: Nprinting Dynamic Filter based on field values

Ruggero_Piccoli — Wed, 11 Mar 2020 13:49:22 GMT

Hi,

You can create a filter that evaluates the value like explained in https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-8.

In the same page you will find also the explanation of the advanced filters.

Best Regards,

Ruggero

Re: Nprinting Dynamic Filter based on field values

Lech_Miszkiewicz — Wed, 11 Mar 2020 22:22:36 GMT

....or

If you are not familiar with NPrinting, create a flag in your Qlik load script to apply required filtering and then in NPrinting you won't need dynamic filter anymore, but just static filter: Flag: numeric value=1

Re: Nprinting Dynamic Filter based on field values

manoj2102 — Thu, 19 Mar 2020 08:50:07 GMT

Thanks Ruggero & Lech for your reply . Both were helpful an i'm able to achieve the same by using combination of script in app and Filter in NP

Script

If(WeekDay(Date)='Mon','3',
If(WeekDay(Date)='Tue','4',
If(WeekDay(Date)='Wed','5',
If(WeekDay(Date)='Thu','1',
If(WeekDay(Date)='Fri','2',
If(WeekDay(Date)='Sat','3',
If(WeekDay(Date)='Sun','3')))))))as schedule

In NP

Evaluate value field Filter as

Pick(Match(weekday(today()),'Mon','Tue','Wed','Thu','Fri'),'1','2','3','4','5')

Apply the same in Report template

Regards

Manoj D.

Re: Nprinting Dynamic Filter based on field values

Ruggero_Piccoli — Thu, 19 Mar 2020 10:00:36 GMT

Hi,

Thanks for sharing the solution with the whole community. This will help many other people in the future.

Best Regards,

Ruggero