Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-07-10 11:36 PM

How to force select one according to another listbox selection.

Hi all,

I am going to force the number selections in some listbox based on another listbox. the sample data are as below:

I got 3 listbox

listbox A

Junior

Senior

Director

ListBox B

Factory

Shop

BackOffice

Listbox C

A

B

I want to do the following:

If i select 'A' listbox C, then I can select anything in listbox A but just can select 1 object in listbox B.

If i select 'B' listbox C, then I can select anything in listbox B but just can select 1 object in listbox A.

Can anyone provide me some suggestion how can I set the listbox?

Thanks.

Best Regards,

Nick

738 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2012-07-10 11:56 PM
Author

Hi,

You could potentially control this with a macro where you set an initial selection based on the change in listbox C and toggle the "Always one selected value" checkbox for Listbox A/B depending on the selection in C.

However, this is pretty cumbersome and not very intuitive for the people using the application.

I would recommend leaving the selections free and then use calculation conditions on the visualizations that you want to do based on the selections so that if you've selected more than one value in both A and B the chart will not calculate and display a helpful message for the required selection base.

309 Views