topic Creating a calculated table? in QlikView https://community.qlik.com/t5/QlikView/Creating-a-calculated-table/m-p/260281#M1184446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to make a chart of how many support cases I have recieved and how many I have solved on a weekly basis. </P><P>I have the fields Case_Id, Submit_Date and Resolved_Date. <BR />Based on the 2 dates I have created to temp. calendars where I have the Submit_YearWeek and Resolved_YearWeek.</P><P>I would believe that I somehow needs to created a table with YearWeek, No of submitted cases, No of Resolved cases,<BR />but I have no idea on how to create this.</P><P>Thanks,</P></BODY></HTML> Wed, 19 Oct 2011 15:29:27 GMT 2011-10-19T15:29:27Z Creating a calculated table? https://community.qlik.com/t5/QlikView/Creating-a-calculated-table/m-p/260281#M1184446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to make a chart of how many support cases I have recieved and how many I have solved on a weekly basis. </P><P>I have the fields Case_Id, Submit_Date and Resolved_Date. <BR />Based on the 2 dates I have created to temp. calendars where I have the Submit_YearWeek and Resolved_YearWeek.</P><P>I would believe that I somehow needs to created a table with YearWeek, No of submitted cases, No of Resolved cases,<BR />but I have no idea on how to create this.</P><P>Thanks,</P></BODY></HTML> Wed, 19 Oct 2011 15:29:27 GMT https://community.qlik.com/t5/QlikView/Creating-a-calculated-table/m-p/260281#M1184446 2011-10-19T15:29:27Z