Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

sgg_gaikwad
New Contributor II

How find out Fiscal year Which will Start From Month of(10 i.e October)...

Expecting configurable Fiscal Year Calendar...

3 Replies

Re: How find out Fiscal year Which will Start From Month of(10 i.e October)...

Hi,

check YearName()

like YearName(DateField,0,10)

Regards

Regards,
Prashant Sangle
sgg_gaikwad
New Contributor II

Re: How find out Fiscal year Which will Start From Month of(10 i.e October)...

Hi Max,

     Thanks for the Reply from the above expression i got the Fiscal year but as i mention i my Query i need these Month Configurable Means,

Suppose i have one excel file where i am passing these month value it may be 10 OR 4 whatever it may be

our Master Calendar should catch that particular value and work according to it.

Will it Possible...?

Thanks!...

Swapnil

ramoncova06
Valued Contributor III

Re: How find out Fiscal year Which will Start From Month of(10 i.e October)...

you could look into a master calendar

Creating A Master Calendar

Community Browser