topic Re: Fiscal Year: Start with Nov(Month) in QlikView

Fiscal Year: Start with Nov(Month)

kulasekhar — Thu, 04 Jun 2015 09:45:04 GMT

Hi All,

Fiscal Year: Start with Nov(Month)

In line chart. Dimenction display like:Nov,Des,Jan,Feb,Mar,Apr

Thanks

Sekhar.

prajapatiamar38 — Thu, 04 Jun 2015 12:13:56 GMT

Hi....

Try like this

For fiscal year write this expression:

Year(If(num(Month([Calender Date]))>=11 ,AddYears([Calender Date],1),([Calender Date]))) As [Fiscal Year]

and

For fiscal month write this exp:

Dual(Month([Calender Date]),Month(If(Month([Calender Date])>=11,AddMonths([Calender Date],-10),AddMonths([Calender Date],+2)))) As [Fiscal Month]

Then take it as a dimension in line chart.

I hope this will help you

Thanks

Thu, 04 Jun 2015 14:27:53 GMT

Hi Shekhar

You can also do it in this way -

Load following fields from calendar qvd file-

Year(Yearstart([Calendar Date], 0,11)) as [Fiscal Year],

Month([Calender Date]) as [Fiscal Month]

Use [Fiscal Month] as your dimension where [Fiscal Year] is your required year.

ex- if ([Fiscal Year] = 2015, [Fiscal Month])

And also sort the dimension on [Calendar Date] so that months appear on dimension in proper order.

Let me know if this solves your problem.