Listbox filter

[#1]

Hello,

My data looks like that:

FieldA	FieldB
X	A
X	B
X	C
Y	A
Y	B

I want to create a listbox that shows only FieldB for FieldA = Y.

I can do that easily with =if(FieldA=Y,FieldB) but I have 4 listboxs that work this way in my dashboard and that is resulting in a perfomance loss.

I think there is a way to do that with some aggregation function, but I just dont know how to do it.

Thanks for any help!

Att,

Luiz Fernando

[#2]

I'm not sure but You still will not be able to do it without using =if() so it will not increase performance

[#3]

Oh... thats bad.

But thanks anyway!

[Caique_Zaniolo]

Is the condition always the same? If that is the case you can create a new Field in your table containing only the values you need.

[#5]

No, its not. I'd have to create more tables

[#6 · Accepted solution]

Verify this way helps.

Creates a expression field and define:

=Aggr(ONLY({<FieldA={'Y'}>} FieldB), FieldB)

The use of set analisys can help in the matter of performance.

[#7]

It works!

But I've had to add =Aggr(ONLY(1{<FieldA={'Y'}>} FieldB), FieldB), so the listbox doesnt lose it's normal functionality

Thank you very much!