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

Can I have a custom order to a listbox with months

I have created script to give me the month from Application date, which is now entered as a field in a general listbox on a dashboard.

Is there a way I can re-order this so that it is not in calendar month order?

I need it to show based on my financial year which begins in August.

Any help greatly appreciated, either by creating fields in script or simple option checking.

Rob

1 Solution

Accepted Solutions
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi

Yes this is possible

What I will do is right click on the chart > Properties > Sort > check the box beside Expression & click on Expression > click on ecclipse (...) then type 

=Match(DIMENSION NAME,'Aug','Sept','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul')

Click ok.

View solution in original post

1 Reply
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi

Yes this is possible

What I will do is right click on the chart > Properties > Sort > check the box beside Expression & click on Expression > click on ecclipse (...) then type 

=Match(DIMENSION NAME,'Aug','Sept','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul')

Click ok.