topic Expression/Order Graph in QlikView

Expression/Order Graph

Fri, 10 Jan 2014 22:21:37 GMT

Hi! I'd like to order my graphic in this way: November, December, January, February and March.

Is possible to enter an expression on the Sort tab to show this order of months ?

Any suggestions greatly appreciated.

Andrea

Re: Expression/Order Graph

Fri, 10 Jan 2014 22:36:02 GMT

Try this in the sort expression:

=Match(YourMonthField, 'Nov', 'Dec' , 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct')

Re: Expression/Order Graph

MK_QSL — Fri, 10 Jan 2014 22:37:28 GMT

Add an inline table in your script

Load * Inline

[

MonthName, SortOrder

November, 1

December, 2

January, 3

etc......

];

Now wherever you want to sort your graph, go to sort table, expression and write =SortOrder make it ascending order

Re: Expression/Order Graph

Fri, 10 Jan 2014 22:54:22 GMT

Thank you for your help!

Re: Expression/Order Graph

Colin-Albert — Fri, 10 Jan 2014 22:56:07 GMT

If you create the monthname as a dual field, the data will sort in numeric order automatically but display the name.

Load dual(MonthName, Sort) as MonthName

Inline [MonthName, Sort

November, 1

December, 2

January, 3

...

] ;

Manish Kachhia wrote:

Add an inline table in your script

Load * Inline

[

MonthName, SortOrder

November, 1

December, 2

January, 3

etc......

];

Now wherever you want to sort your graph, go to sort table, expression and write =SortOrder make it ascending order

Manish Kachhia wrote:

Add an inline table in your script

Load * Inline

[

MonthName, SortOrder

November, 1

December, 2

January, 3

etc......

];

Now wherever you want to sort your graph, go to sort table, expression and write =SortOrder make it ascending order

Re: Expression/Order Graph

Fri, 10 Jan 2014 22:58:23 GMT

Thank you for your help!

Re: Expression/Order Graph

preminqlik — Sat, 11 Jan 2014 15:04:48 GMT

hi rebecca if you use this below expression , the sort order will be changed if you select any field value in month field

=Match(YourMonthField, 'Nov', 'Dec' , 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct')

thats why use below expression in sort tab :

=only({1}Match(YourMonthField, 'Nov', 'Dec' , 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct'))

Hope this helps you

Prem