topic Re: Slider Bar question in QlikView

Slider Bar question

Tue, 18 Sep 2012 12:36:48 GMT

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!

Re: Slider Bar question

Tue, 18 Sep 2012 12:41:03 GMT

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))

Re: Slider Bar question

Tue, 18 Sep 2012 12:52:41 GMT

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 ?

Re: Slider Bar question

whiteline — Tue, 18 Sep 2012 13:23:42 GMT

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

Re: Slider Bar question

Tue, 18 Sep 2012 14:24:02 GMT

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 ?

Re: Slider Bar question

whiteline — Tue, 18 Sep 2012 16:56:46 GMT

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

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

Re: Slider Bar question

whiteline — Tue, 18 Sep 2012 17:02:48 GMT

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

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