This content has been marked as final. Show 2 replies
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)?