# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

## Show excluded/unrelated values in listbox

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

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: Show excluded/unrelated values in listbox

Hello Panos,

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

8 Replies
Not applicable

## Re: Show excluded/unrelated values in listbox

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

Contributor

## Re: Show excluded/unrelated values in listbox

i think DICK mentioned perfect.

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

Not applicable

## Re: Show excluded/unrelated values in listbox

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).

Highlighted
Contributor III

## Re: Show excluded/unrelated values in listbox

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

in the GUI level.

Is it possible?

MVP

## Re: Show excluded/unrelated values in listbox

Hello Panos,

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

Not applicable

## Re: Show excluded/unrelated values in listbox

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

Not applicable

## Re: Show excluded/unrelated values in listbox

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?

MVP

## Re: Show excluded/unrelated values in listbox

Yes, try with if.