13 Replies Latest reply: Dec 30, 2015 3:55 AM by Andy Weir

# Fiscal Year order - qlik sense

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

• ###### Re: Fiscal Year order - qlik sense

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

• ###### Re: Fiscal Year order - qlik sense

Hiya

I cant, but its a line chart

• ###### Re: Fiscal Year order - qlik sense

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.

• ###### Re: Fiscal Year order - qlik sense

Hiya

fiscal year is a dimension

and yes its ordering

2014

2013

2012

2011

2010

2009

2015

• ###### Re: Fiscal Year order - qlik sense

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.

• ###### Re: Fiscal Year order - qlik sense

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

• ###### Re: Fiscal Year order - qlik sense

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

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

• ###### Re: Fiscal Year order - qlik sense

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.

• ###### Re: Fiscal Year order - qlik sense

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

• ###### Re: Fiscal Year order - qlik sense

Hi Joanna,

May be the Fiscal year field is being considered as a text field. Try converting it to a num and give a try. It might solve the issue.

• ###### Re: Fiscal Year order - qlik sense

have any of our suggestions worked/helped?

• ###### Re: Fiscal Year order - qlik sense

I was using financial year, where I should have been using year as the dimension.

all sorted now

thanx

• ###### Re: Fiscal Year order - qlik sense

Good to hear its been sorted, literally in this case.

Please mark any replies as helpful/correct to help other community users with similar issues.