Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search for values bigger than a value

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!

1 Solution

Accepted Solutions
martin59
Specialist II
Specialist II

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

View solution in original post

3 Replies
martin59
Specialist II
Specialist II

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

Not applicable
Author

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

martin59
Specialist II
Specialist II

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

Martin