Qlik Community

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

1 Solution

Accepted Solutions
MVP
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

anutosh_dhar
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
orital81
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
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
MVP

Re: Show excluded/unrelated values in listbox

Yes, try with if.