hiding values in listbox

[thanhphongle]

Hello community,

is there any way to hide specific values depending on other fields in a listbox?

Example:

This is my datebase

Product	Cost
A	100
B	5000
C	4000
D	6000

What I want to create is a listbox which only shows the products with costs over 1000.

Listbox

Product
B
C
D

This Listbox ignores/hides the product A as its cost is below 1000.

Is there any way how to create a listbox like this?

[tresesco · Accepted solution]

Instead of selecting the field directly in the list box, use expression like:

If(Cost>=1000, Product)

[Kushal_Chawda]

If you specifically want to create the Listbox then write below expression in listbox

=aggr(if(sum(Cost)>1000,Product),Product)

[awhitfield]

See the attached, create lookup with the expression:

If(Cost>=1000, Product)

See sample qvw

Andy

[Mark_Little]

Hi,

Would depend how the data is kept in your data model, but for the example supplied it would be

If(Cost>=1000, Product)

As a few people have already suggested.

You could also do this is script as well in the load script.

If(Cost>=1000, Product) as ProductCost group.

Mark

[thanhphongle]

Thank you for your response! Every suggested solution is working well!