Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
gfisch13
Creator II
Creator II

Simple IF condition in expression

Hi Folks....I thought this expression was simple but it keeps throwing an error, what am I doing wrong??

=IF([CASE_STATUS] = "Closed-Fraud", COUNT[CASE_NUMBER])

 

Thanks, George

Labels (1)
1 Solution

Accepted Solutions
Nicole-Smith

You're missing a few parentheses:

=IF([CASE_STATUS] = "Closed-Fraud", COUNT([CASE_NUMBER]))

I would also suggest using set analysis instead of an if statement:

COUNT({<[CASE_STATUS] = {'Closed-Fraud'}>} [CASE_NUMBER])

View solution in original post

2 Replies
Nicole-Smith

You're missing a few parentheses:

=IF([CASE_STATUS] = "Closed-Fraud", COUNT([CASE_NUMBER]))

I would also suggest using set analysis instead of an if statement:

COUNT({<[CASE_STATUS] = {'Closed-Fraud'}>} [CASE_NUMBER])

gfisch13
Creator II
Creator II
Author

Thank you!!  Forgot the syntax for set analysis, appreciate the help!