# Need help with Nested Filtering Method

**URL:** <https://community.glideapps.com/t/need-help-with-nested-filtering-method/75810>\
**Category:** Ask for Help\
**Created:** [August 23, 2024, 9:09am UTC](https://community.glideapps.com/t/need-help-with-nested-filtering-method/75810 "2024-08-23T09:09:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [August 23, 2024, 9:09am UTC](https://community.glideapps.com/t/need-help-with-nested-filtering-method/75810/1 "2024-08-23T09:09:27Z")

</div>

Hi Guys,

I have list of elements in Table

Columns are Name, Followers ,Category, Sub Category, MinNum , MaxNum Location.

I need to be able to filter based on all options after name

like Category, Sub Category, MinNum , MaxNum Location.

PS: Sometimes options can also be left blank but it should check and give other values back.

Condition I Need to check are like If From Location & Followers are more than MinNum and lesser than Are MaxNum and category is this

Etc

how do I do this? I know we have to use a query column. But Somehow when I add second nesting element condition in query it’s always failing.

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f746561fce80f0027622baac5b02a4abfb314c5e.jpeg "Glide: INFINITE and DYNAMIC Filtering!") ](https://www.youtube.com/watch?v=rtbFccDKuH0)

I Saw this video by @Robert_Petitto is this still valid and best way to do it?

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [August 23, 2024, 11:50am UTC](https://community.glideapps.com/t/need-help-with-nested-filtering-method/75810/2 "2024-08-23T11:50:25Z")

</div>

Can I create Multiple query columns for each filtering and Display values in list based on If-ElseIf?

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [August 23, 2024, 12:18pm UTC](https://community.glideapps.com/t/need-help-with-nested-filtering-method/75810/3 "2024-08-23T12:18:41Z")

</div>

Hi Guys,

here is what I did.

I did a lookup for Location and Niche available in my table and Stored the created a joined list of lookup response as Location Joined list and Niche Joined list.

I will enter selected value for Location → Create a SingleValue column to get the selected location → I created a ifelseif column to check wether any location is selected if yes Then I write selected location if not I show Location joined List

Same way for Niche

I ask user to enter upper limit of followers → create single value of upper limit of followers  
I do a ifelseif to see wether single value for upper limit is available if yes then I show upper value else I am showing 10000000000000000  
I ask user to enter lower limit of followers → create single value of lower limit of followers  
I do a ifelseif to see wether single value for lower limit is available if yes then I show lower value else I am showing 0

Then I create a query column which checks for is niche included in Nicheifelse && Location is included in locationfielse && followers \< upperlimitifelse && followers \> lowerlimitifelse

I am getting query response.

**I was to know wether this is acceptable approach?**

Thank you in advance for help.

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 23, 2024, 11:33pm UTC](https://community.glideapps.com/t/need-help-with-nested-filtering-method/75810/4 "2024-08-23T23:33:50Z")

</div>

> [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932):
>
> [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022 
> 
> > **Version 1**
> >
> > \<a href="https://www.youtube.com/watch?v=rtbFccDKuH0" rel="noopener nofollow ugc"\>https://www.youtube.com/watch?v=rtbFccDKuH0\</a\>

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [September 10, 2024, 12:58pm UTC](https://community.glideapps.com/t/need-help-with-nested-filtering-method/75810/5 "2024-09-10T12:58:31Z")

</div>

Hi @ThinhDinh ,

thank you for replying.

**Correct me if I am wrong here**

1. If I need to have multiple selection in my choice component

Should I include “Is Included in Option” ?

 ![Screenshot 2024-09-10 at 6.28.01 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/464f493b95e86419a053f3cde9b62598397c5f53.png)

**Can you tell me whether this is right approach?**

**Also I need to be able to download the selected Value. so I should use the query column right ?**

Thank you in advance.

Regards,  
Dilip