topic Re. :Search for values bigger than a value in QlikView

Search for values bigger than a value

Wed, 05 May 2010 11:05:17 GMT

Hi All,

I would like to ask if there is an easy way to search for values bigger/smaller than a given by the user value in the search box or in a dropdown select.

In the perfect case I would like the user to type: '<1000' and all values smaller than 1000 to be selected in this column/list box etc.

Thanks!

Re. :Search for values bigger than a value

martin59 — Wed, 05 May 2010 11:18:03 GMT

Hi Sergey,

You can enter "<1000" in your list box to filter your datas <1000

Take care of remove the stars if you click on the Magnifying glass.

Martin

Re. :Search for values bigger than a value

Wed, 05 May 2010 11:39:03 GMT

Hi Martin,

I knew that I miss something, but I found that the data was not formatted as number/date but as text. After specifying the correct settings in Number tab, this feature works (but obviously only for numeric values).

Many thanks for the help!

Sergey

Re. :Re: Re. :Search for values bigger than a value

martin59 — Wed, 05 May 2010 11:46:02 GMT

It works also with dates, on condition that the input date has the same format than the field.

Martin