Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
waqasshah
Creator
Creator

Bar Chart Sorting Order Month/Year (MM/YY)

Dear All,

I am developing a dashboard unfortunately I am unable to sort out the bars in a chart. I want them in chronological order. like Oct/16 , Nov /16, Dec 17. The values used for calculations are CompleteMonthNamesRefRcvd and CompleteYearNameRcvd. 

I have attached the screen shots please review them.

Kind Regards

Waqas Shah

12 Replies
tresesco
MVP
MVP

Try like:

Dual(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)) ,

          Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)), 'MMM/YY'))

Chanty4u
MVP
MVP

its_anandrjs

Try with this

Load

Date(Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&RIGHT(CompleteYearNamesRefRcvd,2),'MMM/YY')'MMM/YY') as FielName

From Source;



In sort use

=Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(CompleteYearNamesRefRcvd,2),'MMM/YY')