Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table with Month field, Year field, and Employee Count field
I want to use Month and Year to determine a date so that I hook into my Master Calendar. How do I manipulate Month and Year to end up with a new column in date format that looks like this:
Go to Solution.
MakeDate(Year, Num(Month(Date#(Month, 'MMM'))), 1) as Date
MakeDate(Year, Month, 1) as Date
Date(MakeDate(Year, Num(Month(Date#(Month, 'MMM'))), 1)) as Date
(html, codepage is 1252, embedded labels, table is @1);
Use MakeDate function in script.
Makedate(Year,Month) as Date,
Thanks!! That did it!