topic Re: Sorting Fiscal Year Month in QlikView

Sorting Fiscal Year Month

Mon, 08 Sep 2014 11:26:38 GMT

Hi all

I have a line chart to calculate sales over financial year

Dimension- Month, Fiscal Year(Apr-Mar)

Expression- Sum(Sales)

My prob is I have month in my X axis showing from Jan to Dec but I want to sort it like Apr-Mar.

I have also seen some discussion in community its not working.

I attached the Image of the chart here for reference.

Re: Sorting Fiscal Year Month

PrashantSangle — Mon, 08 Sep 2014 11:32:17 GMT

Hi,

How are creating Your Fiscal Month.

Use MonthName(DateField) as NewMonth

Use NewMonth as your dimension and sort it in ascending.

Regards,

Re: Sorting Fiscal Year Month

maxgro — Mon, 08 Sep 2014 11:35:53 GMT

try to sort by expression (image)

match(Month, 'apr', 'mag', 'giu', 'lug','ago','set','ott','nov','dic','gen','feb','mar')

adaptmonth name to your setting

Re: Sorting Fiscal Year Month

Mon, 08 Sep 2014 11:36:41 GMT

I have 4 fiscal years

Since i am using month in x axis if i use monthname my values are like this Apr2012, Apr2013, Apr2014.

I have not calculated fiscal month

I have only fiscal Year like this YearName(VISIT_DATE, 0, 4) AS FiscalYear in Load

Re: Sorting Fiscal Year Month

PrashantSangle — Mon, 08 Sep 2014 11:38:13 GMT

Hi,

Then Mossimo Suggestion Should Work

Regards,

Re: Sorting Fiscal Year Month

Mon, 08 Sep 2014 11:39:03 GMT

Its working perfectly

Thank you so much

Can you tell me what s the difference between math and wildmatch

Re: Sorting Fiscal Year Month

maxgro — Mon, 08 Sep 2014 11:43:44 GMT

maybe also

if(Month<4, Month+12,Month)

Re: Sorting Fiscal Year Month

Mon, 08 Sep 2014 11:50:11 GMT

Hi,

Create a field as follows in your calender script

if (month(Date)<=$(FiscalMonthAdjust),month(Date)+(12-$(FiscalMonthAdjust)),month(Date)-$(FiscalMonthAdjust)) AS [Fiscal Month Num]

where FiscalMonthAdjust=3;and then in the Sort Tab of the chart properties,add [Fiscal Month Num] in the Expression option provided and dont forget to check the Expression option and unchecking the rest.

Re: Sorting Fiscal Year Month

MK_QSL — Mon, 08 Sep 2014 11:59:11 GMT

Load

If(Match(Name,'Vidhya'),1,0) as MatchFlag,

If(WildMatch(Name,'*dhy*'),1,0) as WildMatchFlag

Inline

[

Name

Vidhya

Annamalai

];

The match function performs a case sensitive comparison.

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Re: Sorting Fiscal Year Month

Mon, 08 Sep 2014 12:02:53 GMT

Thank you so much