topic Re: Date calculations in QlikView

Date calculations

Fri, 05 Jul 2013 08:56:24 GMT

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

Re: Date calculations

Fri, 05 Jul 2013 09:12:09 GMT

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

Re: Date calculations

jagan — Fri, 05 Jul 2013 09:42:51 GMT

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.