Discussion Board for collaboration related to QlikView App Development.
After much browsing through the forum, I still can't seem to get this to work.
I have data that i am loading from an ODBC database.
ODBC CONNECT TO CVM;
SQL SELECT *
Within ACC_QV there is a field:
There is no period in CUST_QV.
Period is a numeric field with the format '201501' for January 2015.
I need to use this period for MoM and YoY analysis.
I have tried:
Date#(period,'YYYYMM') as PeriodDate,
Month(PeriodDate) as PeriodMonth,
Year(PeriodDate) as PeriodYear;
Year(PeriodDate) as PeriodYear
Which keeps coming back with an Error - Date# is not a function.
Please help me in loading the Month and Year fields in the load script?
because Date# is a Qlik function and you use that in the SQL section
In SQL (after SQL select) section you should use SQL functions of your database
In Qlik section (after LOAD, before SQL) you can use Qlik functions
year(PeriodDate) as PeriodYear,
month(PeriodDate) as PeriodMonth
makedate(left(period,4), right(period,2)) as PeriodDate
View solution in original post
Thank you very much for your help!