topic "Less than" as filter issue in Qlik NPrinting

"Less than" as filter issue

Fri, 03 Jun 2016 18:06:48 GMT

Hi All,

Trying to get multiple items selected on QV by telling it to select all values less than 4 as below but for some reason the formula generates empty results. Super confused as why this would be. Any help is greatly appreciated. Thanks!

tyu

Re: "Less than" as filter issue

Daniel_Jenkins — Sun, 05 Jun 2016 00:16:24 GMT

Hi Tennison,

Try:

HTH - Daniel.

Re: "Less than" as filter issue

Sun, 05 Jun 2016 03:34:21 GMT

Hi Daniel.

Wow it worked! Thank you so much for your help! As you can tell, I am a total novice at this. If possible, could you clarify why unchecking the "Evaluate" box works? Does "Evaluate" not process different formulas? As well, is "IsNumeric" supposed to be an option to return Boolean indicating whether the formula returns a numeric value?

Thanks again,

tyu

Re: "Less than" as filter issue

Daniel_Jenkins — Sun, 05 Jun 2016 22:26:41 GMT

Hi Tennison,

NPrinting allows you to create three types of Field based filters:

1. Static filters based on field values. Here you would only use IsNumeric depending on whether the field is numeric or not. Examples:

Fields: Continent{Europe}

Fields: Year{2016} IsNumeric

2. Dynamic filters based on expressions in QlikView syntax. Here you would use IsNumeric depending on whether the field is numeric or not and always check Evaluate. Example:

Fields: Year{Year(Now())} IsNumeric Evaluate

3. Filters based on QlikView Advanced Search. Here you would always start with = and ensure that neither IsNumeric nor Evaluate are checked. Examples:

Fields: Sales {=Sales>50000}

Fields: Salesman {=Salesman like 'S*'}

Here are the relevant tutorials:

How to Create Static and Dynamic Filters Based on Fields

How to Use QlikView Advanced Search with NPrinting Filters

Here is the list of links to all tutorials covering Filters:

QlikView NPrinting 16 Tutorials - Filters & Cycles

HTH - Daniel.