Fiscal Year order - qlik sense

[joeybird]

Hiya

I have this FiscalYear sorting code

if ([Date Referred.Calendar.FiscalYear] = '2015' , 1,

                if ([Date Referred.Calendar.FiscalYear] = '2014' , 2 ,

                                if ([Date Referred.Calendar.FiscalYear] = '2013' , 3,

                                                if ([Date Referred.Calendar.FiscalYear] = '2012' , 4 ,

                                                                if ([Date Referred.Calendar.FiscalYear] = '2011' , 5 ,

                                                                                if ([Date Referred.Calendar.FiscalYear] = '2010' , 6 ,

                                                                                                if ([Date Referred.Calendar.FiscalYear] = '2009', 7, 8)))))))

even I have done this sorting by expression...ascending and descending

2015 always stays bottom of the list...need it to be at the top

please help

[ogster1974]

can you provide a screen shot Joanna of how you are using the year?

[joeybird]

Hiya

I cant, but its a line chart

please help

[ogster1974]

Your fiscal year is a dimension?

and its ordering something like

2015

2011

2012

2013

2014

My guess without seeing is the line chart is ordering on the measure first or another dimension not mentioned but without seeing it I cant help much.

[joeybird]

Hiya

fiscal year is a dimension

and yes its ordering

2014

2013

2012

2011

2010

2009

2015

please help

[ogster1974]

what fields do you have in the sorting section of your chart.

The order in which they appear and the sorting method applied to each one.

Make sure fiscal year is the first one in the list.

[reddy-s · Accepted solution]

Hi Joanna,

I don't think you need such a big expression to achieve this.

Try using these options:

You can toggle between ascending and descending easily.

[joeybird]

Hiya

yes 2015 will be first if I put fiscal year first... but I need it to be my second dimension.

I have number of customers on my left "y" normal axis

on my normal "x" axis I need months to run along the bottom, fiscal year right Y axis of this

please help

[joeybird]

I have already tried this with no joy, hence why I tried an expression

please help

[ogster1974]

have you tired sorting your first dimension by expression using the fiscal year?

sorry i'm flying a bit blind without the full picture.