Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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