Hide Excluded

[brindlogcool]

Hi,

I want to show only the selected values in the list box. I have tried to use the hide excluded but the problem is it is not actually hiding it is in the grey colour and the space is not getting truncated.  Is there any other way to achive this using macros.

[ToniKautto]

Notice that using macros can be a limitation if you want to use AJAX client to access your application.

[swarup_malli]

go to list box properties and select hide excluded option ...

[brindlogcool]

Thanks Toni,

But is there way to display only the selected vlaues in the list box marco.. For e.g i have slected the customer as ABC in listbox 1. And in the list box 2 it should display only the products for the customer A. In hide excluded it is grey coloured and the space is still there.

[Anonymous]

So what you need to do is instead of a list box, create a straight table with grouping as your dimension and this as your expression:  =MAXSTRING({$<[grouping]={'*'}>} [grouping])

Then go to presentation tab and hide the expression column.  That should work.

[Anonymous]

Here is your file with the new "list box"

[#7]

As long as you only want a field value in your "list box" the easiest thing to do is to make a simple "Table Box" with just the one field. In the Presentation properties "Suppress Header Row" to make it look like a list box.

Won't work with expressions though...

[joaogoncalves]

Maybe its late but you can solve with this expression:

=Aggr(IF(MaxString({<[FieldName]=P([FieldName])>}[FieldName])=[FieldName],[FieldName]),[FieldName])

[#9]

Thanks - that's good, and might in some situations be better than the simple table. Because it's an expression though we can't use "Show Alternatives" with it which would be really useful for some of my applications (where users are interested in their own subset of the data).

What would be best is for Qlik(tech?) to update the software so that hide excluded worked as we all think it should.

[joaogoncalves]

Vote here: http://community.qlik.com/ideas/2091