Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I´ve created a slider which shows Percentages and is connected to a variable that I use in a chart.
The layout of my slider currently looks as follows:
As you can see 0% is at the top and 100% is at the bottom. I would like to have the opposite sorting so that 100% is at the top and 0% is at the bottom as this would be more logical for my users. Any ideas how to do this? The sort-function doesn´t seem to be available if I use a variable.
Many thanks in advance.
Best regards,
Carolin
Hi Carolin,
when using a variable in a slider no sorting is possible.
If you want the sorting from top to bottom, you have to do a workaround and add a new table in the load script with the 11 values from 0 to 1. In the slider you can use this field instead of a variable. With this you can use the sorting in your preferred way.
Hope this helps
Burkhard
My first idea was to have a static step of -0.1, but this breaks Qlikview, even though you can have a negative number as the min / max value.
The workaround - aka bodge - is to use megative numbers and then multiply your variable by -1 when you need it. Visually, you can get away with it, I think.
Hi Carolin,
when using a variable in a slider no sorting is possible.
If you want the sorting from top to bottom, you have to do a workaround and add a new table in the load script with the 11 values from 0 to 1. In the slider you can use this field instead of a variable. With this you can use the sorting in your preferred way.
Hope this helps
Burkhard