topic List box, show some values on click in QlikView

List box, show some values on click

Thu, 15 Sep 2016 11:42:41 GMT

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?

Re: List box, show some values on click

robert_mika — Thu, 15 Sep 2016 12:58:27 GMT

Is this listbox with frequency column or with expression?

Could post an example or screenshot?

Re: List box, show some values on click

Or — Thu, 15 Sep 2016 13:08:28 GMT

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:

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.

Re: List box, show some values on click

Thu, 15 Sep 2016 13:09:15 GMT

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.

Re: List box, show some values on click

Thu, 15 Sep 2016 13:20:04 GMT

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

Re: List box, show some values on click

Thu, 15 Sep 2016 14:31:21 GMT

Just what I am looking for

Re: List box, show some values on click

vinod2086 — Thu, 15 Sep 2016 15:28:31 GMT

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

Re: List box, show some values on click

Thu, 15 Sep 2016 21:46:06 GMT

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.