How find out Fiscal year Which will Start From Mon... - Qlik Community

sgg_gaikwad · ‎2015-05-26

Expecting configurable Fiscal Year Calendar...

PrashantSangle · ‎2015-05-26

Hi,

check YearName()

like YearName(DateField,0,10)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

sgg_gaikwad · ‎2015-05-26

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 · ‎2015-05-26

you could look into a master calendar

Creating A Master Calendar

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