https://community.qlik.com/t5/Talend-Studio/replace-a-value-to-NA-when-it-is-greater-than-100/m-p/2273272#M50307 <P>Hi,</P> <P>&nbsp;</P> <P>i need to&nbsp;replace a value to NA when it is greater than -100.</P> <P>&nbsp;</P> <P>&nbsp;i tried a this expression but throwing error.</P> <P>row5.Adjusted_PAT_Rs_m_YOY_3&gt;="-100"?"NA":row5.Adjusted_PAT_Rs_m_YOY_3</P> <P>or</P> <P>row5.Adjusted_PAT_Rs_m_YOY_3&gt;=-100?"NA":row5.Adjusted_PAT_Rs_m_YOY_3</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.JPG" style="width: 960px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7N9.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156949iD9ED598C0D38FC7F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7N9.jpg" alt="0683p000009M7N9.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.JPG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7gP.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143535iD5AC1EEFCD530DD9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7gP.jpg" alt="0683p000009M7gP.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3.JPG" style="width: 901px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7n5.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157247i3258022D568B5CD0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7n5.jpg" alt="0683p000009M7n5.jpg" /></span></SPAN></P> Sat, 16 Nov 2024 04:30:59 GMT Darmesh 2024-11-16T04:30:59Z https://community.qlik.com/t5/Talend-Studio/replace-a-value-to-NA-when-it-is-greater-than-100/m-p/2273272#M50307 <P>Hi,</P> <P>&nbsp;</P> <P>i need to&nbsp;replace a value to NA when it is greater than -100.</P> <P>&nbsp;</P> <P>&nbsp;i tried a this expression but throwing error.</P> <P>row5.Adjusted_PAT_Rs_m_YOY_3&gt;="-100"?"NA":row5.Adjusted_PAT_Rs_m_YOY_3</P> <P>or</P> <P>row5.Adjusted_PAT_Rs_m_YOY_3&gt;=-100?"NA":row5.Adjusted_PAT_Rs_m_YOY_3</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.JPG" style="width: 960px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7N9.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156949iD9ED598C0D38FC7F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7N9.jpg" alt="0683p000009M7N9.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.JPG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7gP.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143535iD5AC1EEFCD530DD9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7gP.jpg" alt="0683p000009M7gP.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3.JPG" style="width: 901px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7n5.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157247i3258022D568B5CD0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7n5.jpg" alt="0683p000009M7n5.jpg" /></span></SPAN></P> Sat, 16 Nov 2024 04:30:59 GMT https://community.qlik.com/t5/Talend-Studio/replace-a-value-to-NA-when-it-is-greater-than-100/m-p/2273272#M50307 Darmesh 2024-11-16T04:30:59Z https://community.qlik.com/t5/Talend-Studio/replace-a-value-to-NA-when-it-is-greater-than-100/m-p/2273273#M50308 Use this expression <BR />Integer.parseInt(row5.Adjusted_PAT_Rs_m_YOY_3)&gt;= -100 ? "NA" : row5.Adjusted_PAT_Rs_m_YOY_3 Tue, 01 Oct 2019 10:13:10 GMT https://community.qlik.com/t5/Talend-Studio/replace-a-value-to-NA-when-it-is-greater-than-100/m-p/2273273#M50308 TRF 2019-10-01T10:13:10Z