topic Re: Except selected range in slider in QlikView

Except selected range in slider

Tue, 10 May 2011 07:01:54 GMT

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

Except selected range in slider

sushil353 — Tue, 10 May 2011 07:06:16 GMT

Hi Ravi ,

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

HTH

Except selected range in slider

Tue, 10 May 2011 07:25:07 GMT

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

Re: Except selected range in slider

erichshiino — Sun, 15 May 2011 22:28:01 GMT

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