1 Reply Latest reply: Jan 26, 2018 8:44 AM by Ruggero Piccoli RSS

    Filter question Nprinting 17 for Qlik Sense

    Ken Flynt

      Can filters in Nprinting be set for either:

       

      1. Not equal

      2. OR

       

      Ex:

       

      1. ProductCategory not equal 'Produce'

      2. Role = 'Management' OR Status = 'Deleted'

       

      Looking specifically for nprinting filter capability from the App section of the website rather than set analysis, filters table level within a report, or other for example.

       

      Would greatly appreciate any info here. Thanks.

       

      Ken

        • Re: Filter question Nprinting 17 for Qlik Sense
          Ruggero Piccoli

          Hi,

           

          1 - No. If the number of distinct values in the field you want to filter is limited you can create a list (item-by-item) of the values you want to keep. An alternative is to create a calculated column in the reload script with a formula that assign the value 1 on the rows you want to keep and 0 in the other and then filter this field.

           

          2 - Same workaround. Create a calculated column that is true when the condition is met.

           

           

          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.