Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kicchu465
Creator
Creator

Sort order

Hi all,

i  want to sort the  bar chart  order by yearmonth

2011-mar

2012-apr

2013-may

2014-jun

i want above order   ,but now its giving mix order

how can i achieve this?

1 Reply
sunny_talwar

Fix this in the script by helpful read your yearmonth field as a date field which has an underlying numeric value. Once you do this, you will be able to sort it numerically

LOAD Date(MonthStart(yearmonth, 'YYYY-MMM')), 'YYYY-MMM') as yearmonth