Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Hide Excluded

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.

Tags (3)
13 Replies
Highlighted
Employee
Employee

Hide Excluded

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

Highlighted
Specialist
Specialist

Hide Excluded

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

Highlighted
Creator III
Creator III

Re: Hide Excluded

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.

Highlighted
Creator III
Creator III

Hide Excluded

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.

Highlighted
Creator III
Creator III

Re: Hide Excluded

Here is your file with the new "list box"

Highlighted
Not applicable

Hide Excluded

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

Highlighted
Partner
Partner

Re: Hide Excluded

Maybe its late but you can solve with this expression:

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

Highlighted
Not applicable

Re: Hide Excluded

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.

Highlighted
Partner
Partner

Re: Hide Excluded