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: 
Anonymous
Not applicable

Sorting a Dimension which has Month_year in bar chat in Qlik Sense

Hi mate ,

I have server build date which has started from MMM-YY to MMM-YY .I have taken this month_year  combination in one axis .I want to sort this from Jan-2013 to Jan- 2017.

My Question is :How to sort the values from Jan_2013 to so on ?

Please help me on this .

1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Hi,

kindly find the attached updated file.

i hope it will help you.

Thanks,

Mukram

View solution in original post

13 Replies
Anil_Babu_Samineni

You need to sort this in Text with Numeric format Ascending order from sort tab of Right preview in QS

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

I would suggest to convert this to a real date, otherwise sorting won't work.

Do it like this:

Date(MakeDate(RIGHT(YOURDATEFIELD,4),LEFT(YOURDATEFIELD,3)),'MMM-YYYY')

Anonymous
Not applicable
Author

Thanks Peter for your resolution,

Do you want me to convert date  in data load Editor ?

I have already did some migration in Data load Editor .Pls see below

  Month(builddate)&'_'&Year(builddate) as Month_year,

Please suggest do I need to give the code line in Data load Editor?

Regards

Sushanta

Anonymous
Not applicable
Author

Hi Anil ,Thanks for your suggestion ,

I did it as you suggested ,I have selected sort Numerically and select Ascending but not worked .

Let me know if you need more explanation .

Regards

Sushanta

Anil_Babu_Samineni

May be attach application, So that we can work for you

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Month_Year Dimension.PNG

Look to the CPU count Month and Year ,which dimension is not sorted ,As advice I have selected sort Numerically and sort Alphabetically. Please help 

woshua5550
Creator III
Creator III

you can create and load a mapping table like this

1.png

and then sort by "SortMonth"

2.png

Anonymous
Not applicable
Author

Thanks Dave ,

I have data from Jan 2013 to Nov 2017 and it will keep on growing .This is no the static data .

As per my knowledge ,The solution you suggest will work for static data .

Regards

Sushanta

Anil_Babu_Samineni

What if we go using auto Sort?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)