Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Stuck with Date Formats any help on this

Can any help on Date Function i am having date column with below format

LastReload
201501

as YYYYMM while using QlikView Chart objects to get Year,Month,Quarter how to achieve from this?

while using in Monthname(LastReload)=>Giving output as Sep 2451 actually expected is Jan 2015?

How to get MonthName(Jan,Feb,Mar....),month(1,2,3,4,5,6....),Quarter(2014Q4,2015Q1,2015Q2,2015Q3,...) all are expected from single Column LastReload

10 Replies
Colin-Albert
Partner - Champion
Partner - Champion

This post and the linked Technical Brief on Dates has a clear explanation of date formatting in QlikView

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right