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

[reddy-s]

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.

[ogster1974]

have any of our suggestions worked/helped?

[joeybird]

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

all sorted now

thanx

[ogster1974]

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.