Trigger for multiple items on a slider

[danielact]

Let's say I have a table with test scores, that range from 1 - 100. The field is called "Score".

I create a slider object with multiple values so the user can select a range of scores he wants to see. I create 2 varables, vScore1 and vScore2. I create a trigger for vScore1: ='>=' & vScore1 on an input. If I create the same type for vScore2, when the user moves the 2nd slider, it will erase the value I got from vScore1. I need to include vScore2 in the trigger from vScore1 and vice-versa.

Any idea on how to do this?

[Miguel_Angel_Baeyens]

Hi,

I may be missing something, but you can specify a range in the same slider object, and use its values stored in two variables in a set analysis to show the expected results. Can you please elaborate on the idea of the triggers?

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[danielact]

I don't want it as a set analysis - I want it to function as a filter, so the other fields will adjust absed on that. Let's say I choose between 65 and 75, I want all the data to reflect that. I'm not just showing one chart that can use a set analysis, I'd be using triggers to set the criteria to select all scores between 65 and 75.

[Miguel_Angel_Baeyens · Accepted solution]

Right then,

Use a trigger that uses a range instead of two limits (you can test it with a button with an Selection action and set Score as field and the following in Select in Field):

>=$(vScore1)<=$(vScore2)

or

='>=' & $(vScore1) & '<=' & $(vScore2)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[danielact]

Thanks, your second suggestion worked.