Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change the default beginning of an axe

Hi, I wish the X-axe started in november ending in october. What do I have to change to get so?

Thanks

30-01-2013 12-08-10.png

1 Solution

Accepted Solutions
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

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 ,'November','December','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sept','Oct')

Click ok.

Let me know if it work.

View solution in original post

6 Replies
Not applicable
Author

HI,

you could try with a calculated dimension showing only months between november and october.

Hope it helps

Giampiero

Not applicable
Author

Sorry I don't understand what the solution is.

Regards

Not applicable
Author

Hi,

I'm Sorry, don't see my past reply.

I didn't understand your question.

I try to find a solution.

regards

Giampiero

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

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 ,'November','December','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sept','Oct')

Click ok.

Let me know if it work.

Not applicable
Author

It works. Thank you.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Glad it worked.

All the best.

Regards,

Gabriel