issues pulling open cases for a specific customer

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i have been having an issue getting a gauge bo9x to display the number of open cases for a specific customer. I have been using the following expression:

=SUM(IF([Customer]='company name' And statecode=0))

statecode is simply a marker for open cases.

I have trawled through the help manual and have no idea why this returns no results, if someone could point me in the right direction it would be most appreciated.

Re: issues pulling open cases for a specific customer

adamdavi3s — Thu, 05 Jan 2017 13:02:48 GMT

Its hard to advise without a bit more detail but firstly I can't see what you're actually trying to sum in your formula?

=SUM(IF([Customer]='company name' And statecode=0)opencases)

or try

Sum({<Customer={'Company name'},statecode={'0'}>}opencases)

topic Re: issues pulling open cases for a specific customer in QlikView

issues pulling open cases for a specific customer

Re: issues pulling open cases for a specific customer