topic Re: Fiscal Year order - qlik sense in App Development

Fiscal Year order - qlik sense

joeybird — Tue, 29 Dec 2015 15:32:18 GMT

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

Re: Fiscal Year order - qlik sense

ogster1974 — Tue, 29 Dec 2015 15:43:34 GMT

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

Re: Fiscal Year order - qlik sense

joeybird — Tue, 29 Dec 2015 15:44:32 GMT

Hiya

I cant, but its a line chart

please help

Re: Fiscal Year order - qlik sense

ogster1974 — Tue, 29 Dec 2015 15:48:09 GMT

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

joeybird — Tue, 29 Dec 2015 15:52:23 GMT

Hiya

fiscal year is a dimension

and yes its ordering

2014

2013

2012

2011

2010

2009

2015

please help

Re: Fiscal Year order - qlik sense

ogster1974 — Tue, 29 Dec 2015 15:54:26 GMT

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

reddy-s — Tue, 29 Dec 2015 16:02:04 GMT

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

joeybird — Tue, 29 Dec 2015 16:03:02 GMT

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

Re: Fiscal Year order - qlik sense

joeybird — Tue, 29 Dec 2015 16:04:49 GMT

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

please help

Re: Fiscal Year order - qlik sense

ogster1974 — Tue, 29 Dec 2015 16:06:11 GMT

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

reddy-s — Tue, 29 Dec 2015 16:09:44 GMT

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

ogster1974 — Tue, 29 Dec 2015 17:06:23 GMT

have any of our suggestions worked/helped?

Re: Fiscal Year order - qlik sense

joeybird — Wed, 30 Dec 2015 08:51:27 GMT

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

ogster1974 — Wed, 30 Dec 2015 08:55:08 GMT

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.