Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
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

please help

1 Solution

Accepted Solutions
reddys310
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:

Capture.PNG

You can toggle between ascending and descending easily.

13 Replies
ogster1974
Honored Contributor II

Re: Fiscal Year order - qlik sense

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

joeybird
Contributor II

Re: Fiscal Year order - qlik sense

Hiya

I cant, but its a line chart

please help

ogster1974
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.

joeybird
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

please help

ogster1974
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.

reddys310
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:

Capture.PNG

You can toggle between ascending and descending easily.

joeybird
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

please help

joeybird
Contributor II

Re: Fiscal Year order - qlik sense

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

please help

ogster1974
Honored Contributor II

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.