topic Re: Problem with simple if statement containing &quot;and&quot; in QlikView https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692960#M674133 <HTML><HEAD></HEAD><BODY><P>Try with this:</P><P></P><P>If("t_invc"=1, if("t_rtrn"=0,1,0)) as Flag_InternalSales, // 1=Yes,0=No</P></BODY></HTML> Thu, 31 Jul 2014 16:24:07 GMT 2014-07-31T16:24:07Z Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692953#M674124 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This statement is not working for me.</P><P>Anyone got a clue of what is wrong?</P><P></P><P>If("t_invc"=1 and "t_rtrn"=0,1,0) as Flag_InternalSales, // 1=Yes,0=No</P><P></P><P>Freddy</P></BODY></HTML> Thu, 31 Jul 2014 15:40:49 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692953#M674124 2014-07-31T15:40:49Z Re: Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692954#M674126 <HTML><HEAD></HEAD><BODY><P>Remove the quotes Freddy</P><P></P><P>Regards,</P><P></P><P>Nilo</P></BODY></HTML> Thu, 31 Jul 2014 15:47:34 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692954#M674126 nilo_pontes 2014-07-31T15:47:34Z Re: Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692955#M674127 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If(t_invc=1 and t_rtrn=0,1,0) as Flag_InternalSales</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Thu, 31 Jul 2014 15:53:02 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692955#M674127 alexandros17 2014-07-31T15:53:02Z Re: Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692956#M674128 <HTML><HEAD></HEAD><BODY><P>Hi, thanks for the input. Do not work to remove quotes as the data model has these quotes from the database.</P></BODY></HTML> Thu, 31 Jul 2014 15:59:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692956#M674128 2014-07-31T15:59:50Z Re: Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692957#M674129 <HTML><HEAD></HEAD><BODY><P>hello try so If(t_invc=1 or t_rtrn=0,1,0) as Flag_InternalSales</P></BODY></HTML> Thu, 31 Jul 2014 16:01:02 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692957#M674129 jer_2011 2014-07-31T16:01:02Z Re: Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692958#M674130 <HTML><HEAD></HEAD><BODY><P>Hi. Sorry guys. "t_rtrn" do not have 0 as a value. Only 1 and 2. That explains it. Thanks again.</P></BODY></HTML> Thu, 31 Jul 2014 16:04:56 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692958#M674130 2014-07-31T16:04:56Z Re: Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692959#M674131 <HTML><HEAD></HEAD><BODY><P>I'm not sure about the quotes, I would remove them in load script.</P><P></P><P>If not possible you can try if this helps (not sure):</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If(["t_invc"]=1 and ["t_rtrn"]=0,1,0) as Flag_InternalSales</SPAN></P></BODY></HTML> Thu, 31 Jul 2014 16:06:47 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692959#M674131 stigchel 2014-07-31T16:06:47Z Re: Problem with simple if statement containing "and" https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692960#M674133 <HTML><HEAD></HEAD><BODY><P>Try with this:</P><P></P><P>If("t_invc"=1, if("t_rtrn"=0,1,0)) as Flag_InternalSales, // 1=Yes,0=No</P></BODY></HTML> Thu, 31 Jul 2014 16:24:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-simple-if-statement-containing-quot-and-quot/m-p/692960#M674133 2014-07-31T16:24:07Z