Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikvw2019
Contributor
Contributor

Slider Chart Month Issue

Table

Dep_DateDep_Month
2/1/2019Feb,2019
4/3/2019April,2019
9/7/2019September,2019
11/7/2018Nov,2018

 

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.Capture.JPG

Capture1.JPG

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

1 Solution

Accepted Solutions
ramasaisaksoft

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')

date.PNG

View solution in original post

1 Reply
ramasaisaksoft

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')

date.PNG