topic Trigger for multiple items on a slider in QlikView

Trigger for multiple items on a slider

danielact — Tue, 18 Oct 2011 19:22:09 GMT

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?

Trigger for multiple items on a slider

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 19:47:12 GMT

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

Trigger for multiple items on a slider

danielact — Tue, 18 Oct 2011 19:49:54 GMT

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.

Re: Trigger for multiple items on a slider

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 20:00:40 GMT

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)

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

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Trigger for multiple items on a slider

danielact — Tue, 18 Oct 2011 20:05:50 GMT

Thanks, your second suggestion worked.