Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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