Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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