Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box, show some values on click

I have a list box with two columns. I would like to show the most used items and hide the rest. The rest of items will be shown available in the list when the users clicks on any button within the list or similar. Something like expand the list on a user action (click, etc.) to show the rest of items (less used).

Is it possible to do it?

1 Solution

Accepted Solutions
Or
Champion
Champion

You could probably achieve this using the "Treeview" display option. Something along the lines of:

Load

If(FieldIsCommon=true(),Field,'Show More Values\' & Field) as ListBoxField;

And then enable Treeview in your list box for this field. The result should look like this:

Untitled.png

I've included the QVW used to generate this, though obviously I used an inline load rather than a dynamic load based on actual data.

View solution in original post

7 Replies
robert_mika
Master III
Master III

Is this listbox with frequency column or with expression?

Could post an example or screenshot?

Or
Champion
Champion

You could probably achieve this using the "Treeview" display option. Something along the lines of:

Load

If(FieldIsCommon=true(),Field,'Show More Values\' & Field) as ListBoxField;

And then enable Treeview in your list box for this field. The result should look like this:

Untitled.png

I've included the QVW used to generate this, though obviously I used an inline load rather than a dynamic load based on actual data.

Not applicable
Author

This list box is populated from an excel field, that is, initially I load data from excel and then I populate the list box by assigning it a field in the general tab. No expressions are used.

Not applicable
Author

ok, I understand you more or less but what is FieldIsCommon in your conditional?

Not applicable
Author

Just what I am looking for

vinod2086
Creator II
Creator II

Hi tony,

for above Req i have one doubt for ex i want to apply same for multiple listboxes that means each list box sholud i create in line table?

or we can create expression ?

am little confused pls help

Not applicable
Author

Are you using the same table for populate all your list boxes? Are your list boxes being populated from the same table but from different fields? I think there is no need to create any expression. Only associate the field and then select "Treeview" display option from list box general tab as orsh_says. Choose your character separator and that's it.

I provide the Or Shoham example modified that shows two listboxes pointing to the same inline table but using different fields.