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
Highlighted
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

Highlighted
MVP & Luminary
MVP & Luminary

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.