topic Re: Slider value sorting not working properly in QlikView

Slider value sorting not working properly

Mon, 07 Mar 2016 11:07:17 GMT

Hi All,

I have a slider with Month values in it (Our Database has the values are characters) and I am sorting this based on the month_id, which is a key associated with each month name. But when I select a month value or a range of month values using the slider, the values become jumbled up and the selection is not proper. I am attaching a dashboard that shows this issues. How else I can sort this slider values, so that even during selection, they are sorted appropriately?

Thanks.

Re: Slider value sorting not working properly

swuehl — Mon, 07 Mar 2016 12:58:34 GMT

Try a sort expression like

=Only({1} month_id)

or try to read your month_name values in as dual values:

Get the Dates Right

Re: Slider value sorting not working properly

Tue, 08 Mar 2016 08:57:42 GMT

Thanks a lot!

The given expression worked!