Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
arvind1494
Valued Contributor

Filter In N printing June 2018

hi all

i got stuck could anyone help me plz

my requirement is i want to generate a report month wise which i had accomplished but if i want 15 days back or 20 days back how can i do in Nprinting

date field is CalendarDate

7 Replies
Employee
Employee

Re: Filter In N printing June 2018

Hi,

Create a filter like the following:

15 days.png

and apply it.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
framacdev
New Contributor III

Re: Filter In N printing June 2018

Hi Arvind,

If I understood correctly your business problem, you want to send for instance at the beginning of August (say 08/01/2018) a report including data that goes back 15 or 20 days respect of the max CalendarDate or Today date?

If that is, I would:

  1. Create a filter located in Apps --> Filters --> Overview (Create the filter with Name, Description and select from the drop down the app you want to connect to
  2. Go to Fields --> click on Add field --> Choose connection --> Values --> Select Evaluate value from the drop down --> write the formula Date(Max(CalendarDate) - 20) Or Date(Today()-20)
  3. Apply the filter to the report or to the task in order to distribute the report
  4. June 2018 NPrinting version lets your send report on a monthly basis

I hope it helps

Best regards,


Francesco

arvind1494
Valued Contributor

Re: Filter In N printing June 2018

i don't want to add all values like this

because my range is from start of the current month upto today


Tell me is this possible to apply range filter

using >= and  <=

Employee
Employee

Re: Filter In N printing June 2018

Hi,

Adding the values as me and Francesco suggested is the only solution at the moment (June 2018). Of course you can adapt the formulas to met your specific case. 

As documented in the official public help site, using < and > in filters at the moment is not supported. I would suggest it if it was supported.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
arvind1494
Valued Contributor

Re: Filter In N printing June 2018

Thank you for your response .

Let me try that

framacdev
New Contributor III

Re: Filter In N printing June 2018

If you want to do something like that, I suggest to create a Flag field in your Master Calendar either in QlikView or Qlik Sense script such as:

If(Date(CalendarDate) >= Date(MonthStart(Today())), 1, 0)  As _FlgMonthly 

Then create a filter with the _FlgMonthly field = 1 in NPrinting to filter out the values from the beginning of the month up to now

Employee
Employee

Re: Filter In N printing June 2018

I agree, but if you want to filter 15 days back or 20 days back as per the first message, you have to create two new fields; one for the 15 days filter and one for the 20.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.