Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
I'm not sure but You still will not be able to do it without using =if() so it will not increase performance
Oh... thats bad.
But thanks anyway!
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.
No, its not. I'd have to create more tables
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.
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!