Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

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

13 Replies
reddy-s
Master II
Master II

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
Partner - Master II
Partner - Master II

have any of our suggestions worked/helped?

joeybird
Creator III
Creator III
Author

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

all sorted now

thanx

ogster1974
Partner - Master II
Partner - Master II

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.