Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional Listbox Entries

Guys,

In a sample dashboard we try to conditionally populate the listbox entries the end-users can select. Besides the listbox there is a slider embedded in the dashboard which dynamically allows the listbox entries to be "filtered". The use case is as follows:

1. User selects a suitable slider value;

2. List box entries are updated according to the new slider value;

3. User selects a value in the list box.

The problem we are facing is that the selected listbox value also selects other values (e.g. score). A short screencast is available at http://www.screencast.com/t/SQEdxJI0 which highlights the problem. The sample dashboard is attached as well.

Any pointers as to prevent the additional selection is appreciated.

Best Regards

- Alex

Environment: Windows 7, QlikView 11.20.11922.0 SR2

Load Script:

// threshold variable

SET vThreshold = 0.3;

// load profile data

LOAD id,

     firstname,

     year

FROM

profiles.csv

(txt, utf8, embedded labels, delimiter is ',', msq);

// load profile score data

LOAD profile,

     id,

     score

FROM

scores.csv

(txt, utf8, embedded labels, delimiter is ',', msq);

Listbox expression:

=if(score >= vThreshold, year)

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     The reason for that is you have calculated listbox, those are not directly coming from table.

     Thus when you select value from a calculated listbox, it will by default select the relevant values from relevant fields.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!