Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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