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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
techvarun
Specialist II
Specialist II

Share a sample to get faster responses

Chanty4u
MVP
MVP

try this

in sort tab...

Expression:

=Match(FieldName,' A','b','c')     lik so on 

or u wan load order  ascending or desc  chk that

waqasshah
Creator
Creator
Author

I have attached screen shots..

tresesco
MVP
MVP

May be sort by expression:

=Date#(YourDateField, 'MMM/YY')

However, ideally this should be taken care in the script itself. You should create the field as a dual, like:

Dual(Left(....)&'/'&Right() , Date#(YourDateField, 'MMM/YY')) as YourDate

Once this is done in the script, the dates would be be automatically sorted in the UI.

its_anandrjs
Champion III
Champion III

Share some sample file make be your date is not in proper format like MMM/YY or MMM YY or MMM /YY

In Sort Tabe use

=Alt(

date#( CompleteMonthNamesRefRcvd &'/'& CompleteYearNameRcvd, 'MMM/YY'   ),

date#( CompleteMonthNamesRefRcvd &' /'& CompleteYearNameRcvd, 'MMM/ YY' ),

date#( CompleteMonthNamesRefRcvd &' '& CompleteYearNameRcvd, 'MMM YY' ) )

Anil_Babu_Samineni

What if you are getting when you un-select all options from SORT tab?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
waqasshah
Creator
Creator
Author

Thanks @tresesco

this function works

but I am trying to create the following in my dimension but it wont work..

=Dual(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)) , Date#(CompleteYearNamesRefRcvd, 'MMM/YY')) .  please help

waqasshah
Creator
Creator
Author

it wont work

waqasshah
Creator
Creator
Author

Thanks but it did not work