Show excluded/unrelated values in listbox

[#1]

Hi,

I am using calculated dimensions in listboxes within my application. When selecting a value in one listbox, excluded and unrelated values in same/other listboxes get hidden. How can I show all values (selected values as green, excluded as gray and so on)?

Many thanks

Panos

[#2]

You probably have the option "Hide excluded" checked in your listbox' properties. Unchecking this will show excluded as grey

[Anonymous]

i think DICK mentioned perfect.

in the general tab there is a check box hide excluded.

[#4]

Thank you both but I had tried this and it did not work. Hence I thought there is something else going on with calculated dimensions and I posted the question (the "Hide excluded" box, when unchecked, solves the problem for "normal" dimensions).

[orital81]

Try calculating the dimentions in the script, it will turn them to normal dimentions

in the GUI level.

Is it possible?

[tresesco · Accepted solution]

Hello Panos,

It seems that you are using AGGR function in your calculated dimesion. If so, then this is normal behavior in list box.

[#7]

I think that may not be possible due to the type of data and data model (using a qvd).

[#8]

Thanks tresesco, I am indeed using aggr function:

=aggr(only({<[Product_name]={A}>}Company),Company)

Do you think I would be better off with an if clause?

[tresesco]

Yes, try with if.