# Choice list doesn't display when filtered

**URL:** <https://community.glideapps.com/t/choice-list-doesnt-display-when-filtered/79359>\
**Category:** Ask for Help\
**Created:** [January 20, 2025, 8:30pm UTC](https://community.glideapps.com/t/choice-list-doesnt-display-when-filtered/79359 "2025-01-20T20:30:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [January 20, 2025, 8:30pm UTC](https://community.glideapps.com/t/choice-list-doesnt-display-when-filtered/79359/1 "2025-01-20T20:30:05Z")

</div>

I have a choice list that is filtered to not display items that don’t have a count \> 0. This works great but when all the items in the list have a count of zero the entire choice component disappears from the layout.

Is there a way to still show the list and since there is no required field - simply still list the component but only the empty selection? My users may get confused when the choice list vanishes.

UPDATE:

I found a workaround that perhaps can be used by others:

1. I created a query column that filtered my list by category. this listed rows that matched thd filter = cat1, cat2, etc
2. I then created a rollup column for the q column that added the sums of the remaining items
3. I created a single value column in the users table that pointed to the rollup sums. So when any given category is out of items i have a way to display a message that says “no more of x” when the choice list disappears.

---

<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:** [January 20, 2025, 11:52pm UTC](https://community.glideapps.com/t/choice-list-doesnt-display-when-filtered/79359/2 "2025-01-20T23:52:22Z")

</div>

> [@Carl\_Johnson](#):
>
> I created a single value column in the users table that pointed to the rollup sums. So when any given category is out of items i have a way to display a message that says “no more of x” when the choice list disappears.

This works, but I assume the reason you don’t do this in the Users table from the start (the query & rollup part) is because they have to be by category?

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [January 21, 2025, 1:09am UTC](https://community.glideapps.com/t/choice-list-doesnt-display-when-filtered/79359/3 "2025-01-21T01:09:03Z")

</div>

you would be correct. thanks for asking
