Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

3 Replies
bill_markham

Gaurand

For converting your date try :

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

Bets Regards,     Bill

rustyfishbones
Master II
Master II

You need to format YearMonth correctly in the Script Editor

something like

2013-11-10_1337.png

Not applicable

Try Below:

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