topic Split Data in QlikView https://community.qlik.com/t5/QlikView/Split-Data/m-p/356786#M578083 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Not sure this one you looking for</P><TABLE border="0" cellpadding="0" cellspacing="0" width="972"><TBODY><TR><TD class="xl65" height="17" width="81">Code</TD><TD class="xl65" width="133">Name</TD><TD class="xl65" width="61">DOB</TD><TD class="xl65" width="65">DOJ</TD><TD class="xl65" width="52">GRADE</TD><TD class="xl65" width="169">DESIGNATION</TD><TD class="xl65" width="96">DEPARTMENT</TD><TD class="xl65" width="74">LOCATION</TD><TD class="xl65" width="55">M / F</TD><TD class="xl65" width="116">Relv. Experience</TD><TD class="xl65" width="34">F1</TD><TD class="xl65" width="36">F2</TD></TR><TR><TD height="17">C010091</TD><TD>Vinay Kumar Sharma</TD><TD align="right" class="xl66">20-Jul-74</TD><TD align="right" class="xl66">12-Feb-97</TD><TD>G4</TD><TD>Assistant Manager Finance</TD><TD>FINANCE</TD><TD>NCR</TD><TD>M</TD><TD>14 Y, 11 M</TD><TD>14 Y</TD><TD>11 M</TD></TR><TR><TD height="17">C010967</TD><TD>Pradeep Kumar</TD><TD align="right" class="xl66">9-May-81</TD><TD align="right" class="xl66">15-Nov-06</TD><TD>G3</TD><TD>Senior Accounts Executive</TD><TD>FINANCE</TD><TD>NCR</TD><TD>M</TD><TD>6 Y, 7 M</TD><TD>6 Y</TD><TD>7 M</TD></TR><TR><TD height="17">C011162</TD><TD>Devender Pal</TD><TD align="right" class="xl66">2-Jun-86</TD><TD align="right" class="xl66">1-Jan-08</TD><TD>G2</TD><TD>Accounts Executive</TD><TD>FINANCE</TD><TD>NCR</TD><TD>M</TD><TD>8 Y, 4 M</TD><TD>8 Y</TD><TD>4 M</TD></TR></TBODY></TABLE><P></P><P></P><P>I added two field (F1 and F2). If this one is you looking for then try two ways to get this done:</P><P>1. Load</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',1) AS [F1],</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',2) AS [F2],</P><P></P><P>2. Use expression</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',1)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',2)</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Sat, 17 Mar 2012 04:36:03 GMT Sokkorn 2012-03-17T04:36:03Z Split Data https://community.qlik.com/t5/QlikView/Split-Data/m-p/356785#M578082 <HTML><HEAD></HEAD><BODY><P>Please anyone can help me to split data then check data: </P><P></P><P>Example:&nbsp; 2 y,3 m</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 y, 4 m</P><P></P><P>then how to check.</P><P></P><P>Data attached,please check?</P><P>Please help any one?</P></BODY></HTML> Sat, 17 Mar 2012 03:50:06 GMT https://community.qlik.com/t5/QlikView/Split-Data/m-p/356785#M578082 2012-03-17T03:50:06Z Split Data https://community.qlik.com/t5/QlikView/Split-Data/m-p/356786#M578083 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Not sure this one you looking for</P><TABLE border="0" cellpadding="0" cellspacing="0" width="972"><TBODY><TR><TD class="xl65" height="17" width="81">Code</TD><TD class="xl65" width="133">Name</TD><TD class="xl65" width="61">DOB</TD><TD class="xl65" width="65">DOJ</TD><TD class="xl65" width="52">GRADE</TD><TD class="xl65" width="169">DESIGNATION</TD><TD class="xl65" width="96">DEPARTMENT</TD><TD class="xl65" width="74">LOCATION</TD><TD class="xl65" width="55">M / F</TD><TD class="xl65" width="116">Relv. Experience</TD><TD class="xl65" width="34">F1</TD><TD class="xl65" width="36">F2</TD></TR><TR><TD height="17">C010091</TD><TD>Vinay Kumar Sharma</TD><TD align="right" class="xl66">20-Jul-74</TD><TD align="right" class="xl66">12-Feb-97</TD><TD>G4</TD><TD>Assistant Manager Finance</TD><TD>FINANCE</TD><TD>NCR</TD><TD>M</TD><TD>14 Y, 11 M</TD><TD>14 Y</TD><TD>11 M</TD></TR><TR><TD height="17">C010967</TD><TD>Pradeep Kumar</TD><TD align="right" class="xl66">9-May-81</TD><TD align="right" class="xl66">15-Nov-06</TD><TD>G3</TD><TD>Senior Accounts Executive</TD><TD>FINANCE</TD><TD>NCR</TD><TD>M</TD><TD>6 Y, 7 M</TD><TD>6 Y</TD><TD>7 M</TD></TR><TR><TD height="17">C011162</TD><TD>Devender Pal</TD><TD align="right" class="xl66">2-Jun-86</TD><TD align="right" class="xl66">1-Jan-08</TD><TD>G2</TD><TD>Accounts Executive</TD><TD>FINANCE</TD><TD>NCR</TD><TD>M</TD><TD>8 Y, 4 M</TD><TD>8 Y</TD><TD>4 M</TD></TR></TBODY></TABLE><P></P><P></P><P>I added two field (F1 and F2). If this one is you looking for then try two ways to get this done:</P><P>1. Load</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',1) AS [F1],</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',2) AS [F2],</P><P></P><P>2. Use expression</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',1)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SubField([Relv. Experience],',',2)</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Sat, 17 Mar 2012 04:36:03 GMT https://community.qlik.com/t5/QlikView/Split-Data/m-p/356786#M578083 Sokkorn 2012-03-17T04:36:03Z