Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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-dynam....
In the same page you will find also the explanation of the advanced filters.
Best Regards,
Ruggero
....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
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.
Hi,
Thanks for sharing the solution with the whole community. This will help many other people in the future.
Best Regards,
Ruggero