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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
1 Solution

Accepted Solutions
ramasaisaksoft
Master
Master

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
Master
Master

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