Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Slider bar variables

Hi

I have this nice slider bar which works perfectly when using numbers but as soon as I switch it to percentages is goes off.

On the main sheet is the original, and on the second sheet is the one working with percentages.I want to use this slider to have a full range in a small area which keeps on scrolling the slider for projections, so there is no real limit  going left or right on the slider. The bottom one shows the higher values, which i will ultimately hide. The top one is giving the issue, you will see when selecting on the right button, it will show the correct percentage on the input box at the top, but the slider itself loses it's position every 4-8 positions.

Hope this makes sense.

If anyone has a better solution that would be great as well. I need to have the option to use quarter percentages in projections are we are talking about multiple billion figures. But i also need to option to do projections not only in single figures but  negative values, as well as going up to even 50%. Better have all the options available for the users, right?

6 Replies
sunny_talwar
Not applicable

Re: Slider bar variables

I have no idea what's doing this, but if I change the static step from 0.0025 (0.25%) to 0.025 (2.5%) the marker is fixed, but this you might already know.

Best,

Sunny

Gysbert_Wassenaar
Not applicable

Re: Slider bar variables

Try setting the min and max values to =floor(vSliderSelectedValue,0.01)-0.02 and =floor(vSliderSelectedValue,0.01)+0.02 respectively.


talk is cheap, supply exceeds demand
Not applicable

Re: Slider bar variables

That is really confusing that it works on 0.025 but not on 0.0025, thanks for having a look though

sunny_talwar
Not applicable

Re: Slider bar variables

That is indeed confusing

Not applicable

Re: Slider bar variables

Works better, but if I continue scrolling from 0 up, it again start throwing out the values between 5 and 7 and then from 9 on again. This is really baffling

Not applicable

Re: Slider bar variables

Any ideas anyone on how to fix this?