Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting Y-Axis on Chart (Years and Months)

Hi,

Im having trouble sorting my y-axis on a chart.  Im my dataset I have the following date identifiers :

(Years are Financial Year - Apr-Mar)

  • year_index (1,2,3,4)
  • montth_index (1-12)
  • Month (Apr, May....Mar)
  • Year (2010/11, 2011/12, 2012/13)

What ever I do to try and sort the y-axis - nothing seems to work.

Any help appreciated.

Fiorano

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Youmay try using the sort expression

year_index & month_index

View solution in original post

6 Replies
Not applicable
Author

Anyone?

khadeer
Specialist
Specialist

In sort tab go to expression in that write by using match r wildmatch function it will work.

Give some sample data i will write expression.

khadeer
Specialist
Specialist

=match(Month,'Apr','May','Jun','Jul','Aug','Sep'.......'Mar')

it will help u

Not applicable
Author

Hi this does help when viewing a single financial year. When I deselect the year filter the Months and financial years are combined eg Apr-2010, Apr-2011, Apr-2012, Feb-2010, Feb-2011 etc...

nagaiank
Specialist III
Specialist III

Youmay try using the sort expression

year_index & month_index

Not applicable
Author

Thanks!