topic Re: Using IF and OR in QlikView https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765480#M663725 <HTML><HEAD></HEAD><BODY><P>=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or</P><P>[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime',1))</P></BODY></HTML> Fri, 09 Jan 2015 18:33:22 GMT MarcoWedel 2015-01-09T18:33:22Z Using IF and OR https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765476#M663721 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a list of Step status in records and I need to determine late and overdue.&nbsp; this is what I have so far, but I get an error out.</P><P></P><P>Any suggestions?</P><P></P><P></P><P></P><P>=<SPAN style="color: #0000ff;">COUNT</SPAN><STRONG style="color: #ff0000;">(</STRONG><SPAN style="color: #0000ff;">IF</SPAN><STRONG style="color: #ff0000;">(</STRONG><SPAN style="color: #800000;">[STATUS_SP]</SPAN> = 'Evaluate' <SPAN style="color: #0000ff;">and</SPAN> <SPAN style="color: #800000;">[EVAL_ONTIME]</SPAN> = 'OnTime') <SPAN style="color: #0000ff;">or</SPAN></P><P><SPAN style="color: #575757;">(</SPAN> <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">[STATUS_SP]</SPAN> = 'Evaluate' <SPAN style="color: #0000ff;">and</SPAN> <SPAN style="color: #800000;">[EVAL_ONTIME]</SPAN> = 'OnTime'),1)</P></BODY></HTML> Fri, 09 Jan 2015 18:20:11 GMT https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765476#M663721 leocattqv 2015-01-09T18:20:11Z Re: Using IF and OR https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765477#M663722 <HTML><HEAD></HEAD><BODY><P>The red indicates unbalanced parens, And there appear to be no difference between the two ifs. I think this is what you want. </P><P></P><P>=COUNT(</P><P>IF(([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') </P><P> ,1)</P><P>)</P><P></P><P>-Rob</P></BODY></HTML> Fri, 09 Jan 2015 18:31:43 GMT https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765477#M663722 rwunderlich 2015-01-09T18:31:43Z Re: Using IF and OR https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765478#M663723 <HTML><HEAD></HEAD><BODY><P>for syntax maybe</P><P></P><P>=COUNT(IF(&nbsp;&nbsp;&nbsp; ([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime')</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,1) )</P></BODY></HTML> Fri, 09 Jan 2015 18:32:20 GMT https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765478#M663723 maxgro 2015-01-09T18:32:20Z Re: Using IF and OR https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765479#M663724 <HTML><HEAD></HEAD><BODY><P>=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or<BR />([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'),1)</P></BODY></HTML> Fri, 09 Jan 2015 18:33:16 GMT https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765479#M663724 Anonymous 2015-01-09T18:33:16Z Re: Using IF and OR https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765480#M663725 <HTML><HEAD></HEAD><BODY><P>=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or</P><P>[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime',1))</P></BODY></HTML> Fri, 09 Jan 2015 18:33:22 GMT https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765480#M663725 MarcoWedel 2015-01-09T18:33:22Z Re: Using IF and OR https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765481#M663726 <HTML><HEAD></HEAD><BODY><P><BR />thanks all, I really appreciate it,&nbsp; that did it.</P></BODY></HTML> Fri, 09 Jan 2015 19:08:45 GMT https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765481#M663726 leocattqv 2015-01-09T19:08:45Z Re: Using IF and OR https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765482#M663727 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><A href="https://community.qlik.com/qlik-users/2286">rwunderlich</A>&nbsp; is right,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or [STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">is equal to</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">so his solution might be the better choice if this is, what you are looking for.</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">regards</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Marco</P></BODY></HTML> Fri, 09 Jan 2015 19:18:21 GMT https://community.qlik.com/t5/QlikView/Using-IF-and-OR/m-p/765482#M663727 MarcoWedel 2015-01-09T19:18:21Z