# Less than operator not working

**URL:** <https://discuss.elastic.co/t/less-than-operator-not-working/106397>\
**Category:** Kibana\
**Created:** [November 5, 2017, 4:58am UTC](https://discuss.elastic.co/t/less-than-operator-not-working/106397 "2017-11-05T04:58:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![karnamonkster](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/karnamonkster/32/67266_2.png) [@karnamonkster](https://discuss.elastic.co/u/karnamonkster)\
**Post date:** [November 5, 2017, 4:58am UTC](https://discuss.elastic.co/t/less-than-operator-not-working/106397/1 "2017-11-05T04:58:27Z")

</div>

Hi,  
I am trying to use a “\<“ operator to filter all the records with field “value” less than 0.5.  
After applying the filter in the query I still get the records which are greater than 0.5  
Here is the snapshot

 ![376592F5-CB91-443F-996E-42C34CA63ED1](https://us1.discourse-cdn.com/elastic/original/3X/8/f/8fe2a02e1c8eaa697a7c10f5ce74f9684f623ecc.jpeg)

I am not sure what is the issue, the field type is also correct

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 5, 2017, 8:09am UTC](https://discuss.elastic.co/t/less-than-operator-not-working/106397/2 "2017-11-05T08:09:34Z")

</div>

I don’t think Kibana supports this.

---

<div class="post-metadata">

**Author:** ![karnamonkster](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/karnamonkster/32/67266_2.png) [@karnamonkster](https://discuss.elastic.co/u/karnamonkster)\
**Post date:** [November 5, 2017, 9:34am UTC](https://discuss.elastic.co/t/less-than-operator-not-working/106397/3 "2017-11-05T09:34:13Z")

</div>

However the query works fine when you dont use decimal For example:

`value:<1`

 ![valquery](https://us1.discourse-cdn.com/elastic/original/3X/5/c/5c9acb319b5908d7646b0962c231ba20413063eb.JPG)

---

<div class="post-metadata">

**Author:** ![karnamonkster](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/karnamonkster/32/67266_2.png) [@karnamonkster](https://discuss.elastic.co/u/karnamonkster)\
**Post date:** [November 19, 2017, 11:23am UTC](https://discuss.elastic.co/t/less-than-operator-not-working/106397/4 "2017-11-19T11:23:40Z")

</div>

This is working fine now, had to change the field "value" to FLOAT from LONG

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 17, 2017, 11:24am UTC](https://discuss.elastic.co/t/less-than-operator-not-working/106397/5 "2017-12-17T11:24:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.