topic Column data- Any one help me please in QlikView https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244213#M93172 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>My source is </P><P></P><TABLE border="1" cellpadding="2" cellspacing="1" dir="ltr" width="216"><TBODY><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Name</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Message</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Sankar</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Accounts/SH1</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Ram</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Accounts/SH2</P></SPAN></TD></TR></TBODY></TABLE><P>I want Display data as below</P><P></P><TABLE border="1" cellpadding="2" cellspacing="1" dir="ltr" width="216"><TBODY><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Name</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Message</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Sankar</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">SH1</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Ram</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">SH2</P></SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 13 Oct 2011 06:10:21 GMT 2011-10-13T06:10:21Z Column data- Any one help me please https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244213#M93172 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>My source is </P><P></P><TABLE border="1" cellpadding="2" cellspacing="1" dir="ltr" width="216"><TBODY><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Name</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Message</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Sankar</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Accounts/SH1</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Ram</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Accounts/SH2</P></SPAN></TD></TR></TBODY></TABLE><P>I want Display data as below</P><P></P><TABLE border="1" cellpadding="2" cellspacing="1" dir="ltr" width="216"><TBODY><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Name</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Message</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Sankar</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">SH1</P></SPAN></TD></TR><TR><TD height="19" width="31%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">Ram</P></SPAN></TD><TD height="19" width="69%"><SPAN style="font-size: 12pt; font-family: Calibri;"><P align="left">SH2</P></SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 13 Oct 2011 06:10:21 GMT https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244213#M93172 2011-10-13T06:10:21Z Column data- Any one help me please https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244214#M93173 <HTML><HEAD></HEAD><BODY><P> in dimension take </P><P>Name </P><P></P><P></P><P>expression&nbsp; write</P><P></P><P>subfield(Message,'/',2)</P><P></P><P></P><P></P><P>or </P><P></P><P>in script </P><P></P><P>subfield(Message,'/',2) as message</P></BODY></HTML> Thu, 13 Oct 2011 06:12:58 GMT https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244214#M93173 SunilChauhan 2011-10-13T06:12:58Z Column data- Any one help me please https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244215#M93174 <HTML><HEAD></HEAD><BODY><P> Use </P><P>Mid(Message,10,len(Message))</P></BODY></HTML> Thu, 13 Oct 2011 06:24:39 GMT https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244215#M93174 2011-10-13T06:24:39Z Column data- Any one help me please https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244216#M93175 <HTML><HEAD></HEAD><BODY><P> Thank Q</P></BODY></HTML> Thu, 13 Oct 2011 06:25:09 GMT https://community.qlik.com/t5/QlikView/Column-data-Any-one-help-me-please/m-p/244216#M93175 2011-10-13T06:25:09Z