topic Sorting by Fiscal Year in QlikView

Sorting by Fiscal Year

darrellbutler — Tue, 08 Mar 2011 14:11:01 GMT

Hi folks,

I have a data set that includes month i.e 01 = Jan, 02 = Feb 12 = Dec. Together with a Year_Month in the format 201004 = Apr 2010, 201005 = May 2010 etc.

I have a line chart and I'm trying to show sales volumes over 3 years. I want to sort my x axes starting from April going through to March but at the moment I'm dtruggling to do this.

I've added two Dimensions Month & Year_Month, Month does not have any sort order, Year_Month has a descending order based on a numeric value.

Any help would be greatly appreciated

Sorting by Fiscal Year

john_duffy — Tue, 08 Mar 2011 15:38:58 GMT

Hello.

I have attached a sample application which creates a resident table to determine the monthly sort order. The line chart then uses the sorting field in the Sort by Expression to have the x axis go from April to March.

Let me know if this helps.

John.

Sorting by Fiscal Year

darrellbutler — Thu, 10 Mar 2011 11:04:49 GMT

John,

Sorry for the late response - I was demoing my first app so things were hectic !

This helped greatly - thank you very much indeed.

Kind regards

Darrell