topic Re: Slider in reversed order in QlikView

Slider in reversed order

Anonymous — Fri, 11 Oct 2013 15:26:45 GMT

Is it possible to get slider, variable-based, in the reversed order? That is, instead of 0 to 100, get 100 to 0, left to right or top to bottom.

I tried set min value to 100 and max to 0 - it didn't do anything. If I set negative step, QV hangs.

It should be simple, but somewhow I can't find it .

Is it imposible???

Thanks,

Michael

Re: Slider in reversed order

Anonymous — Fri, 11 Oct 2013 16:09:56 GMT

A somewhat weird workaround:

Use negative values from -100 to 0, and cover each minus sign with a text object. And, use absolute values in the calculations.

Still, would like a better solution

Re: Slider in reversed order

Gysbert_Wassenaar — Fri, 11 Oct 2013 16:39:29 GMT

Perhaps a dual field: dual(Value,-Value) as Value. Or setting the Number format for the negative values to show as normal: #,##0;#,##0

Re: Slider in reversed order

Anonymous — Fri, 11 Oct 2013 17:38:41 GMT

Thanks GW,

Both dual field and number format work. I prefer number format, no need to create extra field.

Re: Slider in reversed order

swuehl — Fri, 11 Oct 2013 18:24:19 GMT

Just a note:

When using a field, I think you can just sort by number descending. Apparently you can't use this option for a variable.

Re: Slider in reversed order

Anonymous — Fri, 11 Oct 2013 19:31:48 GMT

This is correct Stefan, with field you can sort it in any way.

Strangely, sort wasn't available when I modified the slider originally created with a variable. But if create a new slider from scratch using field, sort works.

Anyway, variable with number format #,##0;#,##0 is a better solution in my case.

Thanks,

Michael

Re: Slider in reversed order

Anonymous — Mon, 14 Oct 2013 17:30:54 GMT

Some follow-up.

The solution with number formatting #,##0;#,##0 is limited. It doesn't help if the range goes accross the 0, for example from 50 to -50. Apparently the only way in this case is to use field.

Re: Slider in reversed order

swuehl — Mon, 14 Oct 2013 17:41:27 GMT

Strangely, sort wasn't available when I modified the slider originally created with a variable. But if create a new slider from scratch using field, sort works.

I also came across this issue, and I think it was due to following:

I you create a slider with option to set variables, the only option in value mode is 'continuous/numeric'.

This won't allow to specify sort order.

If you then change to use a field instead of variables, you need to change the value mode manually to 'Discrete'. This enables sort tab options again.

Re: Slider in reversed order

Anonymous — Mon, 14 Oct 2013 17:49:38 GMT

It helps, thanks Stefan.