topic Re: Subfield in QlikView https://community.qlik.com/t5/QlikView/Subfield/m-p/1237895#M393535 <HTML><HEAD></HEAD><BODY><P>Or</P><P></P><P>mid(user, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Index(user,'\')</SPAN>+1)</P><P></P><P>-Rob</P></BODY></HTML> Wed, 25 Jan 2017 23:22:55 GMT rwunderlich 2017-01-25T23:22:55Z Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237887#M393527 <HTML><HEAD></HEAD><BODY><P>hi i am using subfield in chart but somehow top two user <SPAN style="font-size: 13.3333px;">UK709065 and <SPAN style="font-size: 13.3333px;">UK703562 are not showing&nbsp; basically it dosent have \ on that user</SPAN></SPAN></P><P>my expression of subfield is</P><P></P><P>=SubField([user],'\',2)</P><P></P><P></P><P>UK709065</P><P><SPAN style="font-size: 13.3333px;">UK703562</SPAN></P><P><SPAN style="font-size: 13.3333px;">UTA\Ram</SPAN></P><P><SPAN style="font-size: 13.3333px;">CAMPUS\Juliya</SPAN></P><P><SPAN style="font-size: 13.3333px;">PHM\RAmtu</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><A href="https://community.qlik.com/qlik-users/178253">tamilarasu</A>‌</SPAN></P><P><SPAN style="font-size: 13.3333px;"><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌<BR /></SPAN></P></BODY></HTML> Wed, 25 Jan 2017 21:04:55 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237887#M393527 everest226 2017-01-25T21:04:55Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237888#M393528 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>=If(Index(user,'\'), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SubField([user],'\',2), user)</SPAN></P></BODY></HTML> Wed, 25 Jan 2017 21:11:58 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237888#M393528 swuehl 2017-01-25T21:11:58Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237889#M393529 <HTML><HEAD></HEAD><BODY><P>Now i am getting&nbsp; </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">UK709065</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">UK703562</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">but not this</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">UTA\Ram</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">CAMPUS\Juliya</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">PHM\RAmtu</SPAN></P></BODY></HTML> Wed, 25 Jan 2017 21:33:16 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237889#M393529 everest226 2017-01-25T21:33:16Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237890#M393530 <HTML><HEAD></HEAD><BODY><P>Stefan's expression seems to be working for me</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150906_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Jan 2017 21:56:51 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237890#M393530 sunny_talwar 2017-01-25T21:56:51Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237891#M393531 <HTML><HEAD></HEAD><BODY><P>Seems to work for me:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>user</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>test</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CAMPUS\Juliya</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Juliya</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">UK703562</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">UK703562</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">UK709065</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">UK709065</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">UTA\Ram</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Ram</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>LOAD *,</P><P>If(Index(user,'\'), SubField([user],'\',2), user) as test;</P><P>LOAD * INLINE [</P><P>user</P><P>UK709065</P><P>UK703562</P><P>UTA\Ram</P><P>CAMPUS\Juliya</P><P>];</P></BODY></HTML> Wed, 25 Jan 2017 21:58:51 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237891#M393531 swuehl 2017-01-25T21:58:51Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237892#M393532 <HTML><HEAD></HEAD><BODY><P>stefan's expression is working fine.</P><P>Here is the another one.</P><P>If(SubStringCount(data,'\')=1, SubField(data,'\',2), data)</P></BODY></HTML> Wed, 25 Jan 2017 21:58:58 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237892#M393532 surendraj 2017-01-25T21:58:58Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237893#M393533 <HTML><HEAD></HEAD><BODY><P>Thanks&nbsp;&nbsp; </P></BODY></HTML> Wed, 25 Jan 2017 22:58:29 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237893#M393533 everest226 2017-01-25T22:58:29Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237894#M393534 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Wed, 25 Jan 2017 22:59:46 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237894#M393534 everest226 2017-01-25T22:59:46Z Re: Subfield https://community.qlik.com/t5/QlikView/Subfield/m-p/1237895#M393535 <HTML><HEAD></HEAD><BODY><P>Or</P><P></P><P>mid(user, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Index(user,'\')</SPAN>+1)</P><P></P><P>-Rob</P></BODY></HTML> Wed, 25 Jan 2017 23:22:55 GMT https://community.qlik.com/t5/QlikView/Subfield/m-p/1237895#M393535 rwunderlich 2017-01-25T23:22:55Z