Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
Not applicable

Date Format issue while Creating Rolling Months

Hi All,

I am trying to create a rolling monthly chart for last 12 months with my date format available in 'MMYY'(0113) or 'MMYYYY'(012013) format. I am trying to apply date format formula to it and also addmonths formula for calculations. However its showing entirely different values of dates when i am doing so.

For eg: 1213 is converted to Apr-1903

            122013 is converted to Jan-2234

I have attached my working file to demonstrate this. Please guide me how i can use this to create a rolling months chart and the changes in date format too. Thanks in Advance.

Tags (2)
3 Replies

Re: Date Format issue while Creating Rolling Months

Gaurand

For converting your date try :

     date ( ( date#(YearMonth , 'MMYY' ) ) , 'MM-YYYY' )

Bets Regards,     Bill

rustyfishbones
Honored Contributor II

Re: Date Format issue while Creating Rolling Months

You need to format YearMonth correctly in the Script Editor

something like

2013-11-10_1337.png

Not applicable

Re: Date Format issue while Creating Rolling Months

Try Below:

TEXT(DATE(DATE#(YearMonth, 'MMYY'),'MMM-YYYY'))

Community Browser