Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
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.

13 Replies
ToniKautto
Employee
Employee

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

swarup_malli
Specialist
Specialist

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

brindlogcool
Creator III
Creator III
Author

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.

aaroncouran
Creator III
Creator III

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.

aaroncouran
Creator III
Creator III

Here is your file with the new "list box"

Not applicable

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

Maybe its late but you can solve with this expression:

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

Not applicable

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