Conditional Listbox Entries

Tue, 23 Jul 2013 10:53:51 GMT

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)

Re: Conditional Listbox Entries

kaushiknsolanki — Tue, 23 Jul 2013 11:02:19 GMT

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

topic Re: Conditional Listbox Entries in QlikView

Conditional Listbox Entries

Re: Conditional Listbox Entries