Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

"WHERE" - style clause in QlikView function??

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.

Tags (1)
2 Replies
MVP
MVP

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

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

Regards,

tresesco

Not applicable

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

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

Community Browser