topic Re: Re: Sorting Y Axis dates in QlikView

Sorting Y Axis dates

Thu, 06 Mar 2014 16:39:27 GMT

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

Re: Sorting Y Axis dates

MK_QSL — Thu, 06 Mar 2014 16:44:48 GMT

can you provide your sample file or qvw?

Re: Re: Sorting Y Axis dates

Thu, 06 Mar 2014 16:49:29 GMT

Here goes

Re: Sorting Y Axis dates

Thu, 06 Mar 2014 17:07:17 GMT

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

Re: Sorting Y Axis dates

MK_QSL — Thu, 06 Mar 2014 17:52:40 GMT

Change your First Dimension as below...

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

Re: Sorting Y Axis dates

maxgro — Thu, 06 Mar 2014 18:21:19 GMT

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

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

Re: Sorting Y Axis dates

Thu, 06 Mar 2014 18:48:20 GMT

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

Re: Sorting Y Axis dates

MK_QSL — Thu, 06 Mar 2014 19:03:15 GMT

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

Re: Sorting Y Axis dates

Thu, 06 Mar 2014 19:13:35 GMT

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

Re: Re: Sorting Y Axis dates

Fri, 07 Mar 2014 09:40:09 GMT

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

Re: Sorting Y Axis dates

MK_QSL — Fri, 07 Mar 2014 10:44:30 GMT

Because you have N/A and TBC in your Target Delivery / Release Date field.

You can remove them by ....

=IF([Target Delivery / Release Date] <> 'N/A' and [Target Delivery / Release Date] <> 'TBC' ,

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

Re: Re: Sorting Y Axis dates

Fri, 07 Mar 2014 15:29:37 GMT

Thanks very much Manish, much appreciated.

Rgds

Graham