https://community.qlik.com/t5/QlikView/How-to-create-a-MoM-balance-sheet/m-p/1611427#M445175 <P>As title. I've imported two balance sheets from excel, but they're without&nbsp; the date.</P><P>So I manully add the date by this:</P><P>Emp_temp:<BR />LOAD *,<BR />'2019/07/31' as Date&nbsp;<BR />Resident Balance_sheet_201907;<BR />DROP Table Balance_sheet_201907;&nbsp;</P><P>However, Mastercalendar doesn't work with it.</P><P>How can I fix that?</P> Sat, 16 Nov 2024 02:46:13 GMT samhsieh_ 2024-11-16T02:46:13Z https://community.qlik.com/t5/QlikView/How-to-create-a-MoM-balance-sheet/m-p/1611427#M445175 <P>As title. I've imported two balance sheets from excel, but they're without&nbsp; the date.</P><P>So I manully add the date by this:</P><P>Emp_temp:<BR />LOAD *,<BR />'2019/07/31' as Date&nbsp;<BR />Resident Balance_sheet_201907;<BR />DROP Table Balance_sheet_201907;&nbsp;</P><P>However, Mastercalendar doesn't work with it.</P><P>How can I fix that?</P> Sat, 16 Nov 2024 02:46:13 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-MoM-balance-sheet/m-p/1611427#M445175 samhsieh_ 2024-11-16T02:46:13Z https://community.qlik.com/t5/QlikView/How-to-create-a-MoM-balance-sheet/m-p/1611563#M445181 <P>Hi,</P><P>Try:&nbsp;&nbsp;<SPAN>MakeDate(</SPAN><SPAN>2019, 7, 31) as Date,</SPAN></P><P><SPAN>I assume your master calendar has a field called 'Date'</SPAN></P><P><SPAN>regards,</SPAN></P><P><SPAN>Rutger</SPAN></P> Mon, 12 Aug 2019 12:58:31 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-MoM-balance-sheet/m-p/1611563#M445181 rutger_jansen 2019-08-12T12:58:31Z