Except selected range in slider

[#1]

Hi Everyone,

I am facing the problem with slider.

Here is my requirement, i need to get the data from the slider which is not selected currently i.e; the barchart should display the result according to the slider positon but except the selected portion in slider should not effect to the barchart and other remaining portion should effect in barchart.

Is it possible to work on this? if Yes, plz share your ideas on this....

If my question doesn't make any clear sense for you to understand plz reply me back i will give clear explanation with screenshots.

Thanks

[sushil353]

Hi Ravi ,

Can you please a bit more clear with your problem. or if possible share the screen shot.

HTH

[#3]

hi Sushil,

First of all thanks for ur reply.

But i have already attached the screenshots in my previous post. And in this also i am attaching img below.

I have two buttons Inrange and Outrange.

The Inrange functionality should be which is currently selected portion should effect in barchart.

The Outrange functionality should be which is not currently selected portion should effect in barchart i.e; except currently selected portion of the slider .

If you want any more information plz reply me

Thanks

[erichshiino]

hi,

You can use:

sum  ( {1-$}) value) to get the sum of everything EXCLUDED by all selections.

You could use something like:

sum ( {<FIELD = E( FIELD )> } VALUE)  to get everything excluded by the selection on FIELD (but according to other selections).

I included a sample application on this post, so you can check it on actions.

Please, let me know if it works for you.

Regards,

Erich