Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Filter for Less than or Greater than

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)

5 Replies
vishsaggi
Esteemed Contributor III

Re: Filter for Less than or Greater than

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

MVP
MVP

Re: Filter for Less than or Greater than

This seems like a nPrinting questions vishsaggi

Re: Filter for Less than or Greater than

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

vishsaggi
Esteemed Contributor III

Re: Filter for Less than or Greater than

Ahh! I missed that symbol N. Thanks Sunny.

Employee
Employee

Re: Filter for Less than or Greater than

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.

Community Browser