Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
New 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
Highlighted
Partner
Partner

Re: Number with decimals comparison

Share your expression

Highlighted
New Contributor II

Re: Number with decimals comparison

"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.