topic Re: Multiple listbox with always one value selected in QlikView

Multiple listbox with always one value selected

Fri, 01 May 2015 06:58:22 GMT

Hi all,

I am trying to implement a feature in which we have two list box, based on selection of one list box the other list box data filters out. Based on the selection of the second listbox the charts are plotted. The problem is the charts are irrelevant if none of the values in the second listbox are selected. So there has to be a default value selected for both the listbox at any time.

If we transition from one value to another of the first listbox, corresponding value in the second listbox changes and a default value is also selected.

I have attached a file as a sample. Please suggest me a method to implement the same. Thank you

Re: Multiple listbox with always one value selected

awhitfield — Fri, 01 May 2015 15:38:53 GMT

HI Abinav,

Select one item in the list box, then Open properties and tick the option 'Always One Value Selected' on the General Tab. Repeat this for the second list box.

See Amended dashboard attached.

Andy

Re: Multiple listbox with always one value selected

petter — Fri, 01 May 2015 15:42:44 GMT

Is this something you could use?

I selected one value in the "Level" listbox and then turned on "Always One Selected Value"

For a value to be default for "Level Values" I simply let the minimum string of "Level Values" be the default - because he regular "Always on Selected Value" doesn't work when the data is associated in the way they are here.

The Default (not listbox - it only looks like one...) is constructed with a correctly formatted Text Box so it will display that the default (selected) value is - and the chart will use the MinString ... with a Set Expression to pick it out.

Re: Multiple listbox with always one value selected

Gabriel — Fri, 01 May 2015 15:49:32 GMT

Hi,

I assume you want to have 2nd listbox to show all value even when something is selected, right?

Re: Multiple listbox with always one value selected

Sat, 02 May 2015 07:48:11 GMT

Hi Andrew,

Thank you for responding. I already tried that. The problem is if i am selecting " always one selected" in the second listbox then the first list box is not working properly.

Also, I want all the item to be displayed in the second listbox at any time.

Re: Multiple listbox with always one value selected

Sat, 02 May 2015 08:05:59 GMT

Thank You Petter for the solution. I think this will work.

Just one thing, is it possible that we can also have the default value selected in the "level value" listbox?

Re: Multiple listbox with always one value selected

Sat, 02 May 2015 08:07:16 GMT

Yes Gabriel, i want to show all the values even when one value is selected.

Re: Multiple listbox with always one value selected

Wed, 06 May 2015 08:34:28 GMT

Hi Petter,

Thank you for your help. I am still facing an issue. I can still select multiple values in the second listbox. Can you please suggest any alternative of that. Thank You.

Re: Multiple listbox with always one value selected

Gabriel — Wed, 06 May 2015 08:36:00 GMT

Hi,

But you have marked this question as answer.

Probably best to open another question

Re: Multiple listbox with always one value selected

petter — Wed, 06 May 2015 08:46:24 GMT

There are a couple of ways of getting around that - although selecting multiple can't be prevented - but it can be fixed immediately by some adjustments....

The best might be to:

Create a Trigger on the dimension_value field and let that trigger select the MinString(dimension_value) so only one value will be selected as a result...