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: 
Vignesh1609
Contributor II
Contributor II

Sorting Ascending Quarter month in Bar Chart

Dear All,

Good Day!

I am trying to sort the Quarter Month in Ascending order in Bar Chart, but I cannot sort it properly.

Can anyone guide me in this issue.

I have created the Dimension as "'Q' & CEIL(NUM(MONTH([created date]))/3) &'-'& Month([created date]) ".

Kindly find the attached picture which am facing the issue.

Labels (1)
1 Solution

Accepted Solutions
Durgadevikumar
Partner - Contributor III
Partner - Contributor III

Hi Vignesh,

Good day😊,

This can be achieved by custom sorting. In bar sort under the sort tab please check the expression box. 

sorting.PNG

In that provide the expression as,

=match(Quarter,'Q1_Jan','Q1_Feb','Q1_Mar','Q2_Apr','Q2_May','Q2_JUn','Q3_Jul','Q3_Aug','Q3_Sep','Q4_Oct','Q4_Nov','Q4_Dec')

And give apply and ok

Your Quarter dimension is automatically sorted as according to order mentioned above.

Hope it is useful to you.

Regards,

DurgadeviKumar

View solution in original post

1 Reply
Durgadevikumar
Partner - Contributor III
Partner - Contributor III

Hi Vignesh,

Good day😊,

This can be achieved by custom sorting. In bar sort under the sort tab please check the expression box. 

sorting.PNG

In that provide the expression as,

=match(Quarter,'Q1_Jan','Q1_Feb','Q1_Mar','Q2_Apr','Q2_May','Q2_JUn','Q3_Jul','Q3_Aug','Q3_Sep','Q4_Oct','Q4_Nov','Q4_Dec')

And give apply and ok

Your Quarter dimension is automatically sorted as according to order mentioned above.

Hope it is useful to you.

Regards,

DurgadeviKumar