topic Re: Dynamic Filter Selection in Qlik NPrinting

Dynamic Filter Selection

Smeenakshi23 — Thu, 25 Jan 2018 10:06:15 GMT

I Have a date filed that keeps changing according to the condition ( today and today()+15) . In Nprinting filter i need to add the all the dates .. Dynamically changing date should also be added.

How it is possible ?

Re: Dynamic Filter Selection

darrell_tobin — Thu, 25 Jan 2018 10:13:51 GMT

Hi Soundarya,

Do you have a little more detail please.

Re: Dynamic Filter Selection

Smeenakshi23 — Thu, 25 Jan 2018 10:30:52 GMT

Yes Sure.. There is a custom condition Date filed in my report.. say Usage date ( it contains date for 15 days from today).

I have a import recipient filter Say product Code A,B, etc.... I need the Product Code A details for 15 days alone .. not for the entire dates available in the report , For that i need to add the Usage date( Condition custom field) in the Nprinting filter..

Hope i am not confusing you.

Re: Dynamic Filter Selection

Ruggero_Piccoli — Thu, 25 Jan 2018 11:52:44 GMT

Hi,

In Qlik NPrinting filters is not yet possible to specify a range of date. You need to create a list like the following:

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 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.

Re: Dynamic Filter Selection

luxlux80 — Fri, 26 Jan 2018 14:48:40 GMT

Work around for dynamic filter selection is creating filter value NPrinting report with respective Nprinting filter value set.

Steps:

Create a "Custom Field" in Qlik Sense data load e.g. DateGroup that has Today, last15days, completed1stpreviousquarter etc.

Create NPrinting report "NPrinting last15days Report" add filter by selecting "Custom Field" and select value (e.g. last15days)

For each "Custom Field" value create report a separate Nprinting Report with respective filter added.

Re: Dynamic Filter Selection

Lech_Miszkiewicz — Sat, 27 Jan 2018 11:37:44 GMT

Just create this logic in Qlik, flag records and use flag as a filter.