Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sushantaqlik
New Contributor II

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
Valued Contributor III

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

Hi,

kindly find the attached updated file.

i hope it will help you.

Thanks,

Mukram

View solution in original post

13 Replies

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

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

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)
peter_zierz
New Contributor

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

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')

sushantaqlik
New Contributor II

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

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

sushantaqlik
New Contributor II

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

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

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

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

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)
sushantaqlik
New Contributor II

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

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
Contributor III

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

you can create and load a mapping table like this

1.png

and then sort by "SortMonth"

2.png

sushantaqlik
New Contributor II

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

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

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

What if we go using auto Sort?

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)