Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting Y Axis dates

Hi,

How do I get my Y-Axis dates in the right order (i.e. Jan-14, Feb-14 ...etc) at the mo they're in Ascending which is not helpful.

Thanks

Graham

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Change your First Dimension as below...

=Date#([Target Delivery / Release Date],'MMM-YY')

SAMPLE.JPG.jpg

View solution in original post

11 Replies
MK_QSL
MVP
MVP

can you provide your sample file or qvw?

Not applicable
Author

Here goes

Not applicable
Author

Your release date field has been stored as text and not numeric. In your script, apply this transformation

Alt(Date#([Target Delivery / Release Date],'MMM-YY')) as [Target Delivery / Release Date]

then in your sort by, sort by numeric value ascending

MK_QSL
MVP
MVP

Change your First Dimension as below...

=Date#([Target Delivery / Release Date],'MMM-YY')

SAMPLE.JPG.jpg

maxgro
MVP
MVP

or in the chart goto tab sort and sort Target Delivery / Release Date by expression ascending

=Date#([Target Delivery / Release Date],'MMM-YY')

Not applicable
Author

Thanks for all your responses, they've been a great help.

Coming from a RAD background having used PowerPoint this appears to be a lot more tricky than I first thought.

Rgds

Graham

MK_QSL
MVP
MVP

Can you close the thread by selecting correct/helpful answer?

Not applicable
Author

Its not that its tricky, it just getting your data types right. Once you have them right, these sort of cosmetic changes are quite easy through the intuitive dialog boxes i.e. sort ascending

The only reason this was tricky was because your date field was captured as text. If you don't know yet, a quick tell is when previewing a table, all text values load left indented and numeric, right indented

Cheers,

Byron

Not applicable
Author


Hi Manish,

Just a quick question, how did you get the N/A and TBC to the end? and is it possible not to show the N/A column?

Rgds

Graham