Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Date calculations

Hi

I have a problem with date. In our company, the fiscal year starts in September and some of the data in SAP is based on normal calendar and some are based on fiscal calendar. My question is, what kind of script I should write to convert fiscal year date to normal calendar based date.

Example

Fiscal period 4/2013 means 12/2012 calendar period (Dec 2012)

Thanks,

Regards

Janne

2 Replies
Not applicable

Re: Date calculations

Thanks for the quick reply.

However I think this doesn't work (or more likely I am using it wrong), cause this results only year and I would like to get period also.

So how to convert fiscal period 4/2013 --> calendar period 12/2012

Thanks

regards

Janne

MVP
MVP

Re: Date calculations

Hi,

Try below expression

=Date(AddMonths(MakeDate(Right('4/2013', 4), Left('4/2013', Index('4/2013', '/') - 1)), 8), 'MM/YYYY')

Replace date with you dimension in above expression.

Hope this helps you.

Regards,

Jagan.

Community Browser