topic Re: Two List List Box in QlikView

Two List List Box

upaliwije — Sun, 07 Sep 2014 10:20:07 GMT

I have 2 list box as follows

List Box 1 List box 2

Dept Branch

A 1

B 2

C 3

Branch 1,2,3 come under Dept A

Branch 4,5,6 come under Dept B

Branch 7,8,9 come under Dept C

My requirement is to show Branch 1,2 and 3 in Branch List box if I select Dept A and so on

Pls help to write the expression for thisw

Re: Two List List Box

MarcoWedel — Sun, 07 Sep 2014 10:50:28 GMT

Hi,

that's out-of-the-box QV functionality, i.e. no expression required.

hope this helps

regards

Marco

Re: Two List List Box

upaliwije — Sun, 07 Sep 2014 10:51:28 GMT

I do not understand

Re: Two List List Box

ashfaq_haseeb — Sun, 07 Sep 2014 10:55:00 GMT

Hi,

Do these fields have any logical connection?

I mean do they reside in the same table?

if yes, then this is how qlikview works.

If not then do let me know.

Regards

ASHFAQ

Re: Two List List Box

MarcoWedel — Sun, 07 Sep 2014 10:56:34 GMT

added example above

regards

Marco

Re: Two List List Box

upaliwije — Sun, 07 Sep 2014 11:01:33 GMT

Thanks Marco

I get your point. but as per your example in the branch list box still the branch 4-9 are visible though not highlighted. What I want to see only 1 2 3 branches in the branch list box

Re: Two List List Box

PrashantSangle — Sun, 07 Sep 2014 11:06:41 GMT

Hi,

Create New List Box

Write Expression

Use AGGR(Branch,Dept)

There is change It should as below

Use AGGR(Branch,Branch)

When You select A from Dept Then it will give only 1,2,3

Regards

Re: Two List List Box

upaliwije — Sun, 07 Sep 2014 11:10:55 GMT

Will you please explain a little more

Re: Re: Two List List Box

ashfaq_haseeb — Sun, 07 Sep 2014 11:11:22 GMT

Hi,

For fields available in different table.

Regards

ASHFAQ

Re: Re: Two List List Box

MarcoWedel — Sun, 07 Sep 2014 11:11:55 GMT

the easiest method would be to check the "hide excluded" option:

hope this helps

regards

Marco

Re: Re: Two List List Box

ashfaq_haseeb — Sun, 07 Sep 2014 11:14:01 GMT

Or may be like this with same table.

Regards

ASHFAQ

Re: Two List List Box

stevedark — Sun, 07 Sep 2014 11:19:04 GMT

There is a thread here that may have some interesting thoughts in it for you:

Multiple Column Listbox

The application referenced can be found here:

QlikView App: Multi Column List Box

This shows how you can use a table box and set various properties in order to make the table box behave like a list box. Using these techniques you could have values highlight green when associated values are selected. I would recommend that you don't go with exactly the same colour as selections - as that is going to give false messages to the user.

Hope that helps.

Steve

Re: Re: Two List List Box

PrashantSangle — Sun, 07 Sep 2014 11:19:28 GMT

Hi,

Checked Enclosed File.

It is as per requirement.

Regards,

Re: Two List List Box

upaliwije — Sun, 07 Sep 2014 15:06:03 GMT

Thanks all for your help

Re: Two List List Box

evan_kurowski — Sun, 07 Sep 2014 17:12:27 GMT

Hello upali,

I know I'm late to this thread, but I wanted to suggest an additional option.

If you aggregate a field value over itself it has the effect of producing a result similar to a "hypothetical" GetPossibleValues() function, but in an array form. When placed in a listbox this will produce a dynamically resizing listbox that never shows excluded values, nor leaves blank greyspace. (and since this calculation is driven by the Only() function, this method accepts set-analysis)

Try this expression in a list box:

=AGGR(Only(Branch),Branch)

Re: Re: Two List List Box

MarcoWedel — Sun, 07 Sep 2014 17:41:19 GMT

Nice one.

regards

Marco

Re: Two List List Box

evan_kurowski — Sun, 07 Sep 2014 18:43:00 GMT

If you've ever had the scenario with the extremely large field and 'Hide Excluded' leaves you potentially millions of greyed out blank rows of empty scroll space this can help. In the event sorting or sort expressions may be giving issue and dispersing your associated rows throughout a giant scrollspace, this bubbles a distillation of possible only to the top.

Works well with Multi-Box too. Sometimes prevention of end-user selection of undesirable values is done by applying KEEP type of reductions during scripting. Allowing the full dimension list to load and then reducing by this technique can work too.

i.e. =Aggr(Only({<Dept={$(vMyAllowedDept)}>} Branch), Branch)