topic Re: Right Function Acting Wierd in QlikView https://community.qlik.com/t5/QlikView/Right-Function-Acting-Wierd/m-p/1324096#M516006 <HTML><HEAD></HEAD><BODY><P>In script, use:</P><P>text(Right(BUDCODE,2)) as TwoRightBud,</P></BODY></HTML> Mon, 03 Apr 2017 12:06:40 GMT m_woolf 2017-04-03T12:06:40Z Right Function Acting Wierd https://community.qlik.com/t5/QlikView/Right-Function-Acting-Wierd/m-p/1324095#M516005 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a really strange b<SPAN style="color: #6a6a6a; font-family: arial, sans-serif; font-size: small; text-align: right;">ehavior</SPAN><SPAN style="color: #545454; font-family: arial, sans-serif; font-size: small; text-align: right;"> with the right function.</SPAN></P><P><SPAN style="color: #545454; font-family: arial, sans-serif; font-size: small; text-align: right;">im getting a diffrent result than i <SPAN style="color: #6a6a6a; font-family: arial, sans-serif; font-size: small; text-align: right;">expected which you can understand more easily by the image i attached..</SPAN></SPAN></P><P><SPAN style="text-align: right; color: #6a6a6a; font-size: small; font-family: arial, sans-serif;">you can see the diffrent between the value i get in the text box and the value i get in the "TwoRightBud" Field<IMG alt="qlikview.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158587_qlikview.jpg" style="height: 359px; width: 620px;" /><BR /></SPAN></P><P><SPAN style="text-align: right; color: #6a6a6a; font-size: small; font-family: arial, sans-serif;">any suggestions?<BR /></SPAN></P></BODY></HTML> Sun, 02 Apr 2017 08:11:22 GMT https://community.qlik.com/t5/QlikView/Right-Function-Acting-Wierd/m-p/1324095#M516005 2017-04-02T08:11:22Z Re: Right Function Acting Wierd https://community.qlik.com/t5/QlikView/Right-Function-Acting-Wierd/m-p/1324096#M516006 <HTML><HEAD></HEAD><BODY><P>In script, use:</P><P>text(Right(BUDCODE,2)) as TwoRightBud,</P></BODY></HTML> Mon, 03 Apr 2017 12:06:40 GMT https://community.qlik.com/t5/QlikView/Right-Function-Acting-Wierd/m-p/1324096#M516006 m_woolf 2017-04-03T12:06:40Z Re: Right Function Acting Wierd https://community.qlik.com/t5/QlikView/Right-Function-Acting-Wierd/m-p/1324097#M516007 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Mon, 03 Apr 2017 12:11:34 GMT https://community.qlik.com/t5/QlikView/Right-Function-Acting-Wierd/m-p/1324097#M516007 2017-04-03T12:11:34Z