https://community.qlik.com/t5/QlikView/Simple-IF-condition-in-expression/m-p/1912085#M1218188 <P>Hi Folks....I thought this expression was simple but it keeps throwing an error, what am I doing wrong??</P> <P>=IF([CASE_STATUS] = "Closed-Fraud", COUNT[CASE_NUMBER])</P> <P>&nbsp;</P> <P>Thanks, George</P> Wed, 30 Mar 2022 18:45:31 GMT gfisch13 2022-03-30T18:45:31Z https://community.qlik.com/t5/QlikView/Simple-IF-condition-in-expression/m-p/1912085#M1218188 <P>Hi Folks....I thought this expression was simple but it keeps throwing an error, what am I doing wrong??</P> <P>=IF([CASE_STATUS] = "Closed-Fraud", COUNT[CASE_NUMBER])</P> <P>&nbsp;</P> <P>Thanks, George</P> Wed, 30 Mar 2022 18:45:31 GMT https://community.qlik.com/t5/QlikView/Simple-IF-condition-in-expression/m-p/1912085#M1218188 gfisch13 2022-03-30T18:45:31Z https://community.qlik.com/t5/QlikView/Simple-IF-condition-in-expression/m-p/1912086#M1218189 <P>You're missing a few parentheses:</P> <P><SPAN>=IF([CASE_STATUS] = "Closed-Fraud", COUNT([CASE_NUMBER]))</SPAN></P> <P>I would also suggest using set analysis instead of an if statement:</P> <P>COUNT({&lt;<SPAN>[CASE_STATUS] = {'Closed-Fraud'}&gt;}&nbsp;[CASE_NUMBER])</SPAN></P> Wed, 30 Mar 2022 18:47:48 GMT https://community.qlik.com/t5/QlikView/Simple-IF-condition-in-expression/m-p/1912086#M1218189 Nicole-Smith 2022-03-30T18:47:48Z https://community.qlik.com/t5/QlikView/Simple-IF-condition-in-expression/m-p/1912090#M1218190 <P>Thank you!!&nbsp; Forgot the syntax for set analysis, appreciate the help!</P> Wed, 30 Mar 2022 18:55:26 GMT https://community.qlik.com/t5/QlikView/Simple-IF-condition-in-expression/m-p/1912090#M1218190 gfisch13 2022-03-30T18:55:26Z