topic Hide Excluded in QlikView

Hide Excluded

brindlogcool — Tue, 22 Nov 2011 20:54:42 GMT

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.

Hide Excluded

ToniKautto — Tue, 22 Nov 2011 20:59:25 GMT

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

Hide Excluded

swarup_malli — Tue, 22 Nov 2011 21:03:08 GMT

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

Re: Hide Excluded

brindlogcool — Tue, 22 Nov 2011 21:06:02 GMT

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.

Hide Excluded

Anonymous — Thu, 05 Jan 2012 02:48:09 GMT

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.

Re: Hide Excluded

Anonymous — Thu, 05 Jan 2012 02:50:49 GMT

Here is your file with the new "list box"

Hide Excluded

Thu, 12 Jan 2012 13:48:28 GMT

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

Re: Hide Excluded

joaogoncalves — Tue, 07 Oct 2014 09:49:06 GMT

Maybe its late but you can solve with this expression:

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

Re: Hide Excluded

Tue, 07 Oct 2014 10:03:53 GMT

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.

Re: Hide Excluded

joaogoncalves — Tue, 07 Oct 2014 10:13:44 GMT

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

Re: Hide Excluded

Tue, 07 Oct 2014 10:24:10 GMT

Voted for it almost 2 years ago and still waiting....

Re: Hide Excluded

Wed, 08 Oct 2014 06:28:40 GMT

I too have a relevant problem with the Listbox.

How can I remove blank spaces from the listbox.

Thanks,

Ananth

Re: Hide Excluded

joaogoncalves — Thu, 09 Oct 2014 11:33:37 GMT

This is a Blank Space in Field, In that specific case you can try this:

IF(Len(TRIM([Field]))>0,[Field])

Or correct the field in load script.

Re: Hide Excluded

isaako34 — Wed, 20 Feb 2019 22:25:23 GMT

Thanks, it works for me.