topic Re: Filter for Less than or Greater than in Qlik NPrinting

Filter for Less than or Greater than

Thu, 23 Mar 2017 16:19:54 GMT

Hi,

Not sure how to write a filter so that I only bring in mounts less than $1,000 or greater than $1,000. This is what I have now but it does not work and then brings in all the data possible it appears (vs following my other filters of month and year)

Re: Filter for Less than or Greater than

vishsaggi — Thu, 23 Mar 2017 16:24:26 GMT

Not quite sure I understand, can you share some sample data and expected output to look into?

Re: Filter for Less than or Greater than

sunny_talwar — Thu, 23 Mar 2017 17:21:28 GMT

This seems like a nPrinting questions vishsaggi‌

Re: Filter for Less than or Greater than

Anil_Babu_Samineni — Thu, 23 Mar 2017 17:27:50 GMT

Create 2 variables and May be Un-check the Excluded Check box. I am not expertise in N-Printing. One week I've seen the UI Part seems this same which i assume. Thinks helpful to you

Look here -- Nprinting Multiple Dynamic Values in a Filter

Re: Filter for Less than or Greater than

vishsaggi — Thu, 23 Mar 2017 17:42:35 GMT

Ahh! I missed that symbol N. Thanks Sunny.

Re: Filter for Less than or Greater than

Daniel_Jenkins — Thu, 23 Mar 2017 22:06:45 GMT

Hi Christopher,

I take it you want to show all rows where frozen_total_dollars are not equal to $1,000 correct?

Let's say you have a table like this and you want to filter out the highlighted rows:

Use a filter like this:

or even like this

To get

HTH - Daniel.