Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
beaubellamy
Partner - Contributor III
Partner - Contributor III

filter on list of floating numbers

Hi guys, 

I'm sure there is a simple function that will allow me to do this, but I can't quite find it. 

I have a field that has random floating numbers (0.123, 0.932, 1.132, 1.4332, 3.43, etc) . I would like to be able to create a filter to only show the values above a threshold, where the filter only allows a subset of values to select (say from 0.5 to 1.5 in steps of 0.1 or 0.05). The filter will select this threshold and allow all values above to be displayed, such that a filter selection of 0.55 will only show the field where the value is above this threshold.

The Class function is almost what I'm looking for but I want the upper bound of all values to be the maximum value.

 

 

 

Labels (1)
1 Reply
marcus_sommer

Maybe something like this:

class(aggr(only({< Field = {">=$(lbound)<=$(ubound)"}>} Field), Field), $(clustersize))

- Marcus