Slider Bar question

[#1]

Hi all,

i have a table with a list of companies. For each company i have the number of hits their websites get per day -  so two fields: Company and Hits.

Now, I want to do a slider bar that has 0 as the smallest value and the highest number that i have in the field Hits as the biggest value. (That i was able to do.)

I also want to use the slider bar in a ways that when i e.g. set the first slider to 15000 and the second to 25000 i want only those companies to be selected that have Hits that are in the range 15000 - 25000.

How can this be done ?

Thanks very much!

K

[#2]

Your slider will be based on a variable that you entered into its properties, so let me assume that those variables are vSliderMin and vSliderMax.

In your chart expressions write an expression such as:

SUM(IF(Hits>=vSliderMin AND Hits<=vSliderMax,Hits))

[#3]

Thanks for the reply. But this would only help me in _one_ chart, right ?

I want to make a field selection based on my slider settings...

How can this be done ?

[whiteline]

You could just add a button with Select in Field Trigger to perform such selection.

[#5]

Hmm...and how would i tell this button not to just select one specific value but all values that are below (or over) a value ?

[whiteline]

It's easily if you have Hits field for each company.

Create Action 'Select in Field' and use >15000<25000 as a search string.

[whiteline]

If you want select Company field you can create a listbox:

=aggr(if(Sum(Hits)<15000 and  Sum(Hits)<25000, 'In range', null()), Company)