Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

2 Replies
tresesco
MVP
MVP

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

Regards,

tresesco

Not applicable
Author

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