# Filters on lens

**URL:** <https://discuss.elastic.co/t/filters-on-lens/323795>\
**Category:** Kibana\
**Tags:** kql-kibana-query-language\
**Created:** [January 24, 2023, 8:29am UTC](https://discuss.elastic.co/t/filters-on-lens/323795 "2023-01-24T08:29:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anil\_Alapati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anil_alapati/32/110660_2.png) [@Anil\_Alapati](https://discuss.elastic.co/u/Anil_Alapati)\
**Post date:** [January 24, 2023, 8:29am UTC](https://discuss.elastic.co/t/filters-on-lens/323795/1 "2023-01-24T08:29:34Z")

</div>

Hi,

I created a table using the Lens, with the column names as below.

Name, Age, city, and occupation.

I want to use the filter in the one of the above columns (example age: 27), display all the entries for this table except the age 27, like NOT age: 27, how can I do it?

show all the entries except the age is 27.

Thank you

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [January 25, 2023, 3:37am UTC](https://discuss.elastic.co/t/filters-on-lens/323795/2 "2023-01-25T03:37:10Z")

</div>

You can not filter in the column header you will need to add a filter on the dashboard where you have the visualization. This is an example using Country Code

 ![Screen Shot 2023-01-24 at 7.34.16 PM](https://us1.discourse-cdn.com/elastic/original/3X/f/f/ffb29c68d02d9af1f5f1504204a2729d606e5b91.png)

 ![Screen Shot 2023-01-24 at 7.36.03 PM](https://us1.discourse-cdn.com/elastic/original/3X/2/6/26430be1fa32a4412f0f27061733f4abb33d71a0.png)

---

<div class="post-metadata">

**Author:** ![Anil\_Alapati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anil_alapati/32/110660_2.png) [@Anil\_Alapati](https://discuss.elastic.co/u/Anil_Alapati)\
**Post date:** [January 25, 2023, 5:15am UTC](https://discuss.elastic.co/t/filters-on-lens/323795/3 "2023-01-25T05:15:16Z")

</div>

Thank you.

---

<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:** [February 22, 2023, 5:15am UTC](https://discuss.elastic.co/t/filters-on-lens/323795/4 "2023-02-22T05:15:29Z")

</div>

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