topic Re: Transform Data in QlikView https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2028#M792242 <HTML><HEAD></HEAD><BODY><P>Something like this?</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190335_Untitled.png" style="height: 338px; width: 620px;" /></P></BODY></HTML> Wed, 17 Jan 2018 12:53:23 GMT lorenzoconforti 2018-01-17T12:53:23Z Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2023#M792237 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>PFA,</P><P> I need some assistance in transforming the attached data. I have a fields called <STRONG>TIMESHEET_DATE </STRONG> and <STRONG>HOURS</STRONG>, so what I want to do is to create the <STRONG>Start Date</STRONG> and <STRONG>End Date </STRONG>based on the <STRONG>TIMESHEET_DATE</STRONG> and then calculate the timespent on the <STRONG>Task_Name</STRONG> for each <STRONG>Resource Name</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2023#M792237 zwyne 2020-11-25T16:16:04Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2024#M792238 <HTML><HEAD></HEAD><BODY><P>How to create start date and end date from single field ?</P><P>Do we need to add hours field to Timesheet_Date ?</P></BODY></HTML> Wed, 17 Jan 2018 10:39:49 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2024#M792238 girish2195 2018-01-17T10:39:49Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2025#M792239 <HTML><HEAD></HEAD><BODY><P>Yes please.</P></BODY></HTML> Wed, 17 Jan 2018 11:19:20 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2025#M792239 zwyne 2018-01-17T11:19:20Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2026#M792240 <HTML><HEAD></HEAD><BODY><P>Yes please.</P></BODY></HTML> Wed, 17 Jan 2018 11:19:27 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2026#M792240 zwyne 2018-01-17T11:19:27Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2027#M792241 <HTML><HEAD></HEAD><BODY><P>Hello again, the expected output is as below. The headings 1 - 15, 16 - 31 and e.t.c are two weeks per month and the data for example 84.59 is number of hours for that period.</P><P></P><P><IMG alt="Expected Output.PNG" class="jive-image image-1" src="/legacyfs/online/190342_Expected Output.PNG" style="width: 620px; height: 203px;" /></P></BODY></HTML> Wed, 17 Jan 2018 12:25:59 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2027#M792241 zwyne 2018-01-17T12:25:59Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2028#M792242 <HTML><HEAD></HEAD><BODY><P>Something like this?</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190335_Untitled.png" style="height: 338px; width: 620px;" /></P></BODY></HTML> Wed, 17 Jan 2018 12:53:23 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2028#M792242 lorenzoconforti 2018-01-17T12:53:23Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2029#M792243 <HTML><HEAD></HEAD><BODY><P>Thank you for your assistance. So for the second part do I have to create the Calendar for the Buckets?</P></BODY></HTML> Wed, 17 Jan 2018 13:06:38 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2029#M792243 zwyne 2018-01-17T13:06:38Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2030#M792244 <HTML><HEAD></HEAD><BODY><P>I forgot the second chart you had in your message</P><P></P><P>See attached updated</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190336_Untitled.png" style="height: 330px; width: 620px;" /></P></BODY></HTML> Wed, 17 Jan 2018 13:07:25 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2030#M792244 lorenzoconforti 2018-01-17T13:07:25Z Re: Transform Data https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2031#M792245 <HTML><HEAD></HEAD><BODY><P>See my other post</P></BODY></HTML> Wed, 17 Jan 2018 13:22:51 GMT https://community.qlik.com/t5/QlikView/Transform-Data/m-p/2031#M792245 lorenzoconforti 2018-01-17T13:22:51Z