topic Re: expression in QlikView https://community.qlik.com/t5/QlikView/expression/m-p/1094881#M363757 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; If(SubField(Column1, '-', 2) = 1, 1, 0) as Output;</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>Column1</STRONG></P><P><STRONG>asdf1234-1</STRONG></P><P><STRONG>dfgf2345-11</STRONG></P><P><STRONG>gdd4567cc-1</STRONG></P><P><STRONG>ghj4563ccc-12</STRONG></P><P><STRONG>aser8762-213</STRONG></P><P><STRONG>];</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="121247" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121247_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 11 Apr 2016 16:34:49 GMT sunny_talwar 2016-04-11T16:34:49Z expression https://community.qlik.com/t5/QlikView/expression/m-p/1094880#M363756 <HTML><HEAD></HEAD><BODY><P>hi guys,</P><P></P><P>need assistance on this scenario,</P><P></P><P>data is like this:</P><P></P><P>Column1:</P><P>asdf1234-1</P><P>dfgf2345-11</P><P>gdd4567cc-1</P><P>ghj4563ccc-12</P><P>aser8762-213</P><P></P><P>expected output:</P><P><SPAN style="font-size: 13.3333px;">Column1,OutPut</SPAN></P><P style="font-size: 13.3333px;">asdf1234-1,1</P><P style="font-size: 13.3333px;">dfgf2345-11,0</P><P style="font-size: 13.3333px;">gdd4567cc-1,1</P><P style="font-size: 13.3333px;">ghj4563ccc-12,0</P><P style="font-size: 13.3333px;">aser8762-213,0</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Note for output: If we have only "1" after "-" display as 1 else 0.</P><P style="font-size: 13.3333px;">I tried with mid(),not success-ed completely.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">thanks in advance.</P></BODY></HTML> Mon, 11 Apr 2016 15:48:27 GMT https://community.qlik.com/t5/QlikView/expression/m-p/1094880#M363756 2016-04-11T15:48:27Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/1094881#M363757 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; If(SubField(Column1, '-', 2) = 1, 1, 0) as Output;</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>Column1</STRONG></P><P><STRONG>asdf1234-1</STRONG></P><P><STRONG>dfgf2345-11</STRONG></P><P><STRONG>gdd4567cc-1</STRONG></P><P><STRONG>ghj4563ccc-12</STRONG></P><P><STRONG>aser8762-213</STRONG></P><P><STRONG>];</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="121247" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121247_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 11 Apr 2016 16:34:49 GMT https://community.qlik.com/t5/QlikView/expression/m-p/1094881#M363757 sunny_talwar 2016-04-11T16:34:49Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/1094882#M363758 <HTML><HEAD></HEAD><BODY><P>another</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG> if( right(<SPAN style="font-size: 13.3333px;">Column1,2)='-1',1,0) as Output</SPAN>;</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>Column1</STRONG></P><P><STRONG>asdf1234-1</STRONG></P><P><STRONG>dfgf2345-11</STRONG></P><P><STRONG>gdd4567cc-1</STRONG></P><P><STRONG>ghj4563ccc-12</STRONG></P><P><STRONG>aser8762-213</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121250_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 11 Apr 2016 16:37:54 GMT https://community.qlik.com/t5/QlikView/expression/m-p/1094882#M363758 Kushal_Chawda 2016-04-11T16:37:54Z