Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
mel78
Contributor II
Contributor II

Number with decimals comparison

I am trying to do a expression where numbers should be greater than and less than expression.  For example , I am trying to filter numbers which are greater than 7 and less than 14. But for some reason, I am getting some values out of range. For example, I see result with 14.5

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

Share your expression

mel78
Contributor II
Contributor II
Author

"Aggr(Median({1<$(vFilters)>}  FieldNameXXX), FieldName) >= VFrom AND Aggr(Median({1<$(vFilters)>} FieldNameXXX), FieldName) <= vTo"

The weird things is that 7 to 14 gives me 14.5 , but 7 to 15 works fine.