topic Re: check field in QlikView https://community.qlik.com/t5/QlikView/check-field/m-p/120966#M18522 <HTML><HEAD></HEAD><BODY><P>-(IsNum(A) and Len(A)=4<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> and B='FR</SPAN>) as SomeFieldName</P></BODY></HTML> Sun, 26 Aug 2018 20:05:38 GMT MarcoWedel 2018-08-26T20:05:38Z check field https://community.qlik.com/t5/QlikView/check-field/m-p/120958#M18514 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hi,<BR /><BR />I try to test A_B_C<BR /><BR />if A = Num '0000' and B = 'FR', 1, 0<BR /><BR /><BR /><BR />thank you in advance<BR />Best regards <BR />Maurice</SPAN></P></BODY></HTML> Fri, 24 Aug 2018 14:59:12 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120958#M18514 MauriceLudo 2018-08-24T14:59:12Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120959#M18515 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">if(A = 0 and B = 'FR', 1, 0) as WhatEver</SPAN></P></BODY></HTML> Fri, 24 Aug 2018 15:01:56 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120959#M18515 m_woolf 2018-08-24T15:01:56Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120960#M18516 <HTML><HEAD></HEAD><BODY><P>Could you explain more?</P></BODY></HTML> Fri, 24 Aug 2018 15:02:08 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120960#M18516 PabloTrevisan 2018-08-24T15:02:08Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120961#M18517 <HTML><HEAD></HEAD><BODY><P>Not without seeing your data and having a better understanding of what you are after.</P><P>All I did is write your statement using correct QV syntax.</P></BODY></HTML> Fri, 24 Aug 2018 15:07:16 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120961#M18517 m_woolf 2018-08-24T15:07:16Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120962#M18518 <HTML><HEAD></HEAD><BODY><P>Yes, I asked him if he can explain better than he wishes.</P></BODY></HTML> Fri, 24 Aug 2018 15:11:10 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120962#M18518 PabloTrevisan 2018-08-24T15:11:10Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120963#M18519 <HTML><HEAD></HEAD><BODY><P>Sorry Pablo. I confused you with Maurice.</P></BODY></HTML> Fri, 24 Aug 2018 15:18:41 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120963#M18519 m_woolf 2018-08-24T15:18:41Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120964#M18520 <HTML><HEAD></HEAD><BODY><P>A = <SPAN lang="en">A is a numerical 4 digit </SPAN></P><P><SPAN lang="en">B <SPAN lang="en">equal FR</SPAN></SPAN></P></BODY></HTML> Fri, 24 Aug 2018 15:53:07 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120964#M18520 MauriceLudo 2018-08-24T15:53:07Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120965#M18521 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P>If(Len(A)=4 and B = 'FR', 1, 0)</P></BODY></HTML> Sat, 25 Aug 2018 14:45:05 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120965#M18521 BalaBhaskar_Qlik 2018-08-25T14:45:05Z Re: check field https://community.qlik.com/t5/QlikView/check-field/m-p/120966#M18522 <HTML><HEAD></HEAD><BODY><P>-(IsNum(A) and Len(A)=4<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> and B='FR</SPAN>) as SomeFieldName</P></BODY></HTML> Sun, 26 Aug 2018 20:05:38 GMT https://community.qlik.com/t5/QlikView/check-field/m-p/120966#M18522 MarcoWedel 2018-08-26T20:05:38Z