topic Re: Show excluded/unrelated values in listbox in QlikView https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507725#M554330 <HTML><HEAD></HEAD><BODY><P>Try calculating the dimentions in the script, it will turn them to normal dimentions</P><P>in the GUI level.</P><P></P><P>Is it possible?</P></BODY></HTML> Wed, 21 Aug 2013 11:43:16 GMT orital81 2013-08-21T11:43:16Z Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507721#M554324 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I am using calculated dimensions in listboxes within my application. When selecting a value</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> 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)?</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Many thanks</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Panos<BR /></SPAN></P></BODY></HTML> Tue, 20 Aug 2013 12:48:01 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507721#M554324 2013-08-20T12:48:01Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507722#M554325 <HTML><HEAD></HEAD><BODY><P>You probably have the option "Hide excluded" checked in your listbox' properties. Unchecking this will show excluded as grey</P></BODY></HTML> Tue, 20 Aug 2013 13:39:50 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507722#M554325 2013-08-20T13:39:50Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507723#M554327 <HTML><HEAD></HEAD><BODY><P>i think DICK mentioned perfect.</P><P>in the general tab there is a check box hide excluded.</P></BODY></HTML> Tue, 20 Aug 2013 14:08:02 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507723#M554327 Anonymous 2013-08-20T14:08:02Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507724#M554329 <HTML><HEAD></HEAD><BODY><P>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).</P></BODY></HTML> Tue, 20 Aug 2013 15:02:18 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507724#M554329 2013-08-20T15:02:18Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507725#M554330 <HTML><HEAD></HEAD><BODY><P>Try calculating the dimentions in the script, it will turn them to normal dimentions</P><P>in the GUI level.</P><P></P><P>Is it possible?</P></BODY></HTML> Wed, 21 Aug 2013 11:43:16 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507725#M554330 orital81 2013-08-21T11:43:16Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507726#M554331 <HTML><HEAD></HEAD><BODY><P>Hello Panos,</P><P>It seems that you are using AGGR function in your calculated dimesion. If so, then this is normal behavior in list box.</P></BODY></HTML> Wed, 21 Aug 2013 11:57:41 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507726#M554331 tresB 2013-08-21T11:57:41Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507727#M554332 <HTML><HEAD></HEAD><BODY><P>I think that may not be possible due to the type of data and data model (using a qvd).</P></BODY></HTML> Wed, 21 Aug 2013 12:09:29 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507727#M554332 2013-08-21T12:09:29Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507728#M554333 <HTML><HEAD></HEAD><BODY><P>Thanks tresesco, I am indeed using aggr function:</P><P></P><P>=aggr(only({&lt;[Product_name]={A}&gt;}Company),Company)</P><P></P><P>Do you think I would be better off with an if clause?</P></BODY></HTML> Wed, 21 Aug 2013 12:13:43 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507728#M554333 2013-08-21T12:13:43Z Re: Show excluded/unrelated values in listbox https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507729#M554334 <HTML><HEAD></HEAD><BODY><P>Yes, try with if.</P></BODY></HTML> Wed, 21 Aug 2013 12:24:32 GMT https://community.qlik.com/t5/QlikView/Show-excluded-unrelated-values-in-listbox/m-p/507729#M554334 tresB 2013-08-21T12:24:32Z