LibreOffice Calc - Filtered Validity

Hi to all,
I’d like to create a dropdown list with the Validity function filtering the cell:
I’ve in the A column the product name and in the E column the quantity; i’d like to have only the row where quantity is greather than zero.
(in a database I’ll do something like this with SELECT A FROM TABLE WHERE E>0)
Is there a way to do it?



Pulse the arrow in the column E header, select Standard Filter…, then in Field name select column E, in Condition select >, and in Value type 0, OK.

If you want to add more information, you can edit your question, or comment an answer. Do not use Answer to comment.

Mark the circle to the left of the answer that solves your question.

Try this formula

IF([rangeQTY] > 0; [rangeProducts]; "")

and set on “Sort entries…”

It works like a charm!