5 Replies Latest reply: Jan 27, 2018 6:37 AM by Lech Miszkiewicz RSS

    Dynamic Filter Selection

    soundarya meenakshi

      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

          Hi Soundarya,

          Do you have a little more detail please.

            • Re: Dynamic Filter Selection
              soundarya meenakshi

              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

              Hi,

               

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

              15 days.png

               

               

              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
                lux kim

                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

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