# Excluding field which return null in Kibana

**URL:** https://discuss.elastic.co/t/excluding-field-which-return-null-in-kibana/26882
**Category:** Kibana
**Created:** [August 5, 2015, 11:27am UTC](https://discuss.elastic.co/t/excluding-field-which-return-null-in-kibana/26882 "2015-08-05T11:27:08Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Saket\_Kumar](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@Saket\_Kumar](https://discuss.elastic.co/u/Saket_Kumar)
#### Post date: [August 5, 2015, 11:27am UTC](https://discuss.elastic.co/t/excluding-field-which-return-null-in-kibana/26882/1 "2015-08-05T11:27:08Z")

</div>

I am retriving field1 on x-axis and which returns null and values. I want to show only those which has some value than which return null.

I see Exclude Pattern in Advance. Can it be excluded from there?

 ![](https://us1.discourse-cdn.com/elastic/original/2X/4/4d4229b80dca8d93360e9a402ec53421d0dc7e46.png)

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [August 11, 2015, 11:19pm UTC](https://discuss.elastic.co/t/excluding-field-which-return-null-in-kibana/26882/2 "2015-08-11T23:19:03Z")

</div>

I don't think you can do that from the exclude patterns, but you could combine this visualization with an "exists" filter: [Where to add a missing filter in this Kibana search](https://discuss.elastic.co/t/where-to-add-a-missing-filter-in-this-kibana-search/24845/2)  
[https://www.elastic.co/guide/en/elasticsearch/guide/current/\_dealing\_with\_null\_values.html](https://www.elastic.co/guide/en/elasticsearch/guide/current/_dealing_with_null_values.html)

---

<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: [July 6, 2017, 2:15pm UTC](https://discuss.elastic.co/t/excluding-field-which-return-null-in-kibana/26882/3 "2017-07-06T14:15:02Z")

</div>


