"Less than" as filter issue

[#1]

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

[Daniel_Jenkins · Accepted solution]

Hi Tennison,

Try:

HTH - Daniel.

[#3]

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

[Daniel_Jenkins]

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.