topic Re: Filtering using inequalities in QlikView

Filtering using inequalities

Wed, 25 Nov 2020 16:16:04 GMT

Hi! If I want to filter a data set using an inequality (say I want all records where a column's value is greater than 45), is there a simpler way to do this other than selecting all those records that have the column's value greater than 45?

Thanks!

Re: Filtering using inequalities

sunny_talwar — Wed, 20 Apr 2016 21:59:48 GMT

Are you trying to filter using search within list box? May be look here

The Search String

https://community.qlik.com/blogs/qlikviewdesignblog/2015/03/16/expression-searches

Text searches

Compound Search - demystified

Re: Filtering using inequalities

awhitfield — Thu, 21 Apr 2016 11:34:04 GMT

Hi Isaac,

are you trying to do this is a list box? Or something else?

Andy

Re: Filtering using inequalities

marcus_sommer — Thu, 21 Apr 2016 13:01:05 GMT

I think you could simple use: >45 and for how it worked take a look on the links from Sunny.

- Marcus

Re: Filtering using inequalities

florentina_doga — Thu, 21 Apr 2016 14:49:51 GMT

try this in list box

>1000,<2000