# Filtering ranges

**URL:** <https://community.glideapps.com/t/filtering-ranges/66611>\
**Category:** Ask for Help\
**Created:** [September 29, 2023, 3:39am UTC](https://community.glideapps.com/t/filtering-ranges/66611 "2023-09-29T03:39:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryanb12](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryanb12/32/64617_2.png) [@Ryanb12](https://community.glideapps.com/u/Ryanb12)\
**Post date:** [September 29, 2023, 3:39am UTC](https://community.glideapps.com/t/filtering-ranges/66611/1 "2023-09-29T03:39:54Z")

</div>

Hi all, I need some help with filtering. I saw one post from about a year and a half ago but not sure if it’s still relevant to what I’m trying to accomplish.

I built a real estate app (Similar to Zillow), the issue I am having is filtering the prices by ranges. I would like to set a min and max price range. The issue is that even though the new built in features automatically pull the data (See attached pics). It’s basically just a checkbox. Is there any way/creative ideas around this?

 ![Screen Shot 2023-09-28 at 7.24.29 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b9c234a18d6160b80470c8e3240da3124f5a366.jpeg)

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [September 29, 2023, 9:00am UTC](https://community.glideapps.com/t/filtering-ranges/66611/2 "2023-09-29T09:00:46Z")

</div>

In the Data Editor, in the table with the price, create an if-then-else computed column to define the ranges.

For example:

- If price \< 50, then “Below $50”
- If price ≥51 and \<100, then “Between $50 and $100”
- Else “Above $100”

Back to the in-app filter in the Layout Editor, add a filter and filter on this if-then-else column.

EDIT: This solution is incorrect. [Please see Darren’s **correct solution** below](https://community.glideapps.com/t/filtering-ranges/66611/5).

---

<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:** [September 30, 2023, 2:36am UTC](https://community.glideapps.com/t/filtering-ranges/66611/3 "2023-09-30T02:36:52Z")

</div>

An alternative for what you stated above (specifically to handle the ≥51 and \<100 part since it looks like 2 conditions in 1).

- If price \> 100, then “Above $100”
- If price ≥ 51, then “Between $50 and $100”
- Else, then “Below $50”.

---

<div class="post-metadata">

**Author:** ![Ryanb12](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryanb12/32/64617_2.png) [@Ryanb12](https://community.glideapps.com/u/Ryanb12)\
**Post date:** [September 30, 2023, 8:42pm UTC](https://community.glideapps.com/t/filtering-ranges/66611/4 "2023-09-30T20:42:20Z")

</div>

@nathanaelb  
@ThinhDinh

Thank you both! Tested and both of these work!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 1, 2023, 3:41am UTC](https://community.glideapps.com/t/filtering-ranges/66611/5 "2023-10-01T03:41:20Z")

</div>

> [@nathanaelb](#):
>
> - If price \< 50, then “Below $50”
> - If price ≥51 and \<100, then “Between $50 and $100”
> - Else “Above $100”

You wouldn’t actually be able to configure the second case, because each case can only have one condition 😉  
Also, a price of $100 would return “Above $100”  
And any price between $50.00 and $50.99 would also return “Above $100”

> [@ThinhDinh](#):
>
> - If price \> 100, then “Above $100”
> - If price ≥ 51, then “Between $50 and $100”
> - Else, then “Below $50”.

Not quite strictly correct, because a price of $50 would return “Below $50”

I’d do it like this:

- If price is greater than 100, then “Above $100”
- If price is equal to or greater than 50, then “Between $50 and $100”
- Else “Below $50”

 ![CleanShot 2023-10-01 at 11.38.48@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd26f88a996132d436c0c7ae70ce5624f426a53b.jpeg)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 8, 2023, 3:41am UTC](https://community.glideapps.com/t/filtering-ranges/66611/6 "2023-10-08T03:41:21Z")

</div>

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