Slider Chart Month Issue

qlikvw2019 — Wed, 25 Nov 2020 16:16:04 GMT

Table

I have a Slider Chart , based on the Dep_Month , however the months are not sorted in order of DATE. Its displaying the months in alphabetical order.

I am using below expession in the sort

=date(date#([dep_month], 'MMM-YYYY'), 'YYYY-MM-DD')

Note: db_month was pupolated by Alteryx DateTimeformat() function

Re: Slider Chart Month Issue

ramasaisaksoft — Thu, 27 Jun 2019 07:20:35 GMT

what is the issue? and what is your expected output?

as i understand your slider is showing more than 4 Month dates( your source table Dev_Month is having only 4 months)

if my assumption is correct

=Date#([Dep_Month], 'MMM-YYYY')