2 Replies Latest reply: Aug 31, 2012 8:44 AM by Wojciech Parzyszek RSS

    "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.