topic Re: Sort computed x axis in QlikView

Sort computed x axis

marco_puccetti — Fri, 28 Aug 2015 09:22:38 GMT

Hello, i need to know how to sort an x dimension of a graph in order to have the dates ordered.

The computed dimension is: =[Month] & '/' & [Year]

that in the graph is showed like the figure attached.

How can i do to get this field ordered by month and year?

Thanks

Marco

arulsettu — Fri, 28 Aug 2015 09:30:39 GMT

post your sample app

crusader_ — Fri, 28 Aug 2015 09:30:43 GMT

Hello, Marco

When you create MonthYear field use dual function, smth like below:

=dual([Month]&'/'&[Year],[Year]*100+[Month])

And sort as number Ascending.

Hope this helps.

Regards,

Andrei

Anonymous — Fri, 28 Aug 2015 09:39:25 GMT

Hi Marco,

You can go to the sort tab. Uncheck all the checkboxes. Check the expression box and enter you expression into it. Please see screenshot:

Peter_Cammaert — Fri, 28 Aug 2015 09:52:01 GMT

Switch places for Month and Year in your calculated dimension.

marco_puccetti — Fri, 28 Aug 2015 09:59:38 GMT

With dual it works.

Thanks

Marco

Fri, 28 Aug 2015 10:29:40 GMT

You can also write the expression on the chart or use Max(Date) if you have date field.