topic Split the data in QlikView https://community.qlik.com/t5/QlikView/Split-the-data/m-p/485323#M181314 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hi All.</P><P></P><P style="text-align: left;">I have one field </P><P style="text-align: left;">Name</P><P style="text-align: left;"><STRONG>A:1 B:2 C:3 D:4</STRONG></P><P></P><P style="text-align: left;"><STRONG>i want to display </STRONG></P><P></P><P style="text-align: left;"><STRONG>A 1</STRONG></P><P style="text-align: left;"><STRONG>B 2</STRONG></P><P style="text-align: left;"><STRONG>C 3</STRONG></P><P style="text-align: left;"><STRONG>D 4</STRONG></P><P></P><P></P><P style="text-align: left;"><STRONG>Thanks in Advancee................<BR /></STRONG></P></BODY></HTML> Mon, 12 Aug 2013 14:29:01 GMT Nagaraju_KCS 2013-08-12T14:29:01Z Split the data https://community.qlik.com/t5/QlikView/Split-the-data/m-p/485323#M181314 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hi All.</P><P></P><P style="text-align: left;">I have one field </P><P style="text-align: left;">Name</P><P style="text-align: left;"><STRONG>A:1 B:2 C:3 D:4</STRONG></P><P></P><P style="text-align: left;"><STRONG>i want to display </STRONG></P><P></P><P style="text-align: left;"><STRONG>A 1</STRONG></P><P style="text-align: left;"><STRONG>B 2</STRONG></P><P style="text-align: left;"><STRONG>C 3</STRONG></P><P style="text-align: left;"><STRONG>D 4</STRONG></P><P></P><P></P><P style="text-align: left;"><STRONG>Thanks in Advancee................<BR /></STRONG></P></BODY></HTML> Mon, 12 Aug 2013 14:29:01 GMT https://community.qlik.com/t5/QlikView/Split-the-data/m-p/485323#M181314 Nagaraju_KCS 2013-08-12T14:29:01Z Re: Split the data https://community.qlik.com/t5/QlikView/Split-the-data/m-p/485324#M181315 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P></P><P>Load Replace(SubField(Name,' '),':',' ') as Name;</P><P>Load * Inline</P><P>[</P><P>Name</P><P>A:1 B:2 C:3 D:4</P><P>];</P></BODY></HTML> Mon, 12 Aug 2013 14:40:17 GMT https://community.qlik.com/t5/QlikView/Split-the-data/m-p/485324#M181315 MayilVahanan 2013-08-12T14:40:17Z