topic split Multiple dates in QlikView https://community.qlik.com/t5/QlikView/split-Multiple-dates/m-p/1366167#M615265 <HTML><HEAD></HEAD><BODY><P>hi Anil, here is sample data file attached</P><P>each date in each row , <STRONG>0.5 hrs</STRONG> as new column without hrs, <STRONG>Total:2hrs</STRONG> needs to go I have 60 colums like this having variable no. of entries in one cell . I am working in QlikSense.</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE style="width: 187px;"><TBODY><TR><TD height="108" style="border: 0px black; border-image: none;" width="187"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2016/05/02: 0.5 hrs<BR /> 2016/08/31: 0.5 hrs<BR /> 2016/11/21: 0.5 hrs<BR /> 2017/02/27: 0.5 hrs<BR /> Total: 2 hrs</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 14 Jun 2017 06:06:56 GMT 2017-06-14T06:06:56Z split Multiple dates https://community.qlik.com/t5/QlikView/split-Multiple-dates/m-p/1366167#M615265 <HTML><HEAD></HEAD><BODY><P>hi Anil, here is sample data file attached</P><P>each date in each row , <STRONG>0.5 hrs</STRONG> as new column without hrs, <STRONG>Total:2hrs</STRONG> needs to go I have 60 colums like this having variable no. of entries in one cell . I am working in QlikSense.</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE style="width: 187px;"><TBODY><TR><TD height="108" style="border: 0px black; border-image: none;" width="187"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2016/05/02: 0.5 hrs<BR /> 2016/08/31: 0.5 hrs<BR /> 2016/11/21: 0.5 hrs<BR /> 2017/02/27: 0.5 hrs<BR /> Total: 2 hrs</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 14 Jun 2017 06:06:56 GMT https://community.qlik.com/t5/QlikView/split-Multiple-dates/m-p/1366167#M615265 2017-06-14T06:06:56Z Re: split Multiple dates https://community.qlik.com/t5/QlikView/split-Multiple-dates/m-p/1366168#M615266 <HTML><HEAD></HEAD><BODY><P>see also <A href="https://community.qlik.com/thread/263794">Split multiple dates from one cell into separate rows/records- Qlik Sesnse</A></P></BODY></HTML> Wed, 14 Jun 2017 21:47:09 GMT https://community.qlik.com/t5/QlikView/split-Multiple-dates/m-p/1366168#M615266 MarcoWedel 2017-06-14T21:47:09Z