topic Single Value, Variable based, Slider Sort order in QlikView

Single Value, Variable based, Slider Sort order

chriscammers — Tue, 21 Sep 2010 19:46:42 GMT

I have a slider using a variable for value in a what-if scenario. I am showing the slider oriented vertically. I'd like the values on the slider to sort descending from top to bottom. The default behaviour is to sort ascending from top to bottom. I've tried inverting the min and max values and using a negative step value.

Single Value, Variable based, Slider Sort order

Tue, 21 Sep 2010 19:57:57 GMT

It's kind of a kludgy solution, but how about making your values negative.
Min: -10
Max: 0
Static Step: 1

Then format it as Money and use the format:

#,##0.;#,##0.

That way, the values appear to be positive and will be sorted in descending order.

Then you would probably want another variable that was your slider variable times -1 and use that in your expressions to hold the correct intended slider value.

Single Value, Variable based, Slider Sort order

chriscammers — Tue, 21 Sep 2010 20:02:46 GMT

That would work but my range is from -.05 to .05

Thanks for thinking about it though.

I appreciate it.

Single Value, Variable based, Slider Sort order

Tue, 21 Sep 2010 21:05:22 GMT

The same idea would work in that situation.
Min: -.5
Max: .5
Static Step: .1

Money Format: -#,##0.0;#,##0.0

Then you still need the second variable to multiply the value by -1.