Qlik Sense App Development

Contributor II

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

1 Solution

Accepted Solutions
Honored Contributor II

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.

13 Replies
Honored Contributor II

Re: Fiscal Year order - qlik sense

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

Contributor II

Re: Fiscal Year order - qlik sense

Hiya

I cant, but its a line chart

Honored Contributor II

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.

Contributor II

Re: Fiscal Year order - qlik sense

Hiya

fiscal year is a dimension

and yes its ordering

2014

2013

2012

2011

2010

2009

2015

Honored Contributor II

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.

Honored Contributor II

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.

Contributor II

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

Contributor II

Re: Fiscal Year order - qlik sense

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