topic "WHERE" - style clause in QlikView function?? in QlikView

"WHERE" - style clause in QlikView function??

Fri, 31 Aug 2012 10:38:15 GMT

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.

Re: "WHERE" - style clause in QlikView function??

tresB — Fri, 31 Aug 2012 10:49:24 GMT

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

Regards,

tresesco

Re: "WHERE" - style clause in QlikView function??

Fri, 31 Aug 2012 12:44:51 GMT

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