"WHERE" - style clause in QlikView function??

[#1]

I'm doing some analysis of support calls. Each call reference has a status to indicate if it's being worked on, on hold etc.

What I want to do is create some text boxes at the top of the page that show the total number of calls at each status. Is there a way I can do a 'where' type function in QlikView, so if I create a Text Object and put into the Text field something like ='Number of Calls at Status 1: ' & Count(CallRef WHERE Status = 1)?

Thanks.

[tresesco]

WHERE can be replace with IF in the front end. isn't it?

Regards,

tresesco

[#3]

='Number of Calls at Status 1: ' & Count({$<Status={1}>}CallRef)