topic Search Expression by > or < in QlikView

Search Expression by > or <

Thu, 18 Aug 2011 02:47:31 GMT

Is there a setting or something special that I can do to an expression to allow users to search by < or > a value? It currently only allows me to search by exact search or part of a number, but I need to be able to filter results by anything less than or greater than a given number.

Search Expression by > or <

nagaiank — Thu, 18 Aug 2011 02:56:36 GMT

If the listbox is for a numeric field, <n and >n work to select numbers less and greater than 'n'

Search Expression by > or <

kaushiknsolanki — Thu, 18 Aug 2011 05:37:15 GMT

Hi,

In expression also you can use the <n and >n, but you should delete ** populated when you search.

Regards,

Kaushik Solanki

Search Expression by > or <

Thu, 18 Aug 2011 17:58:58 GMT

I think there is a bug because it will only work for values greather than 200 (in my case) and not for any number less than that.

Search Expression by > or <

ToniKautto — Thu, 18 Aug 2011 18:19:59 GMT

Thaht sounds a bit strange. Could you post a sample so we can see your data and expression?