topic Numeric Based Criteria in QlikView

Numeric Based Criteria

Tue, 10 Nov 2009 23:02:09 GMT

Afternoon all,

I think I have managed to confuse myself and Qlikview as I cant get what I thought was a relatively easy expression to work.

I am trying to only show records where there has been at least 1 hang up. Below is an example expression that I got working (thanks to help from here) and a count of the hang ups then some crazy formula i was trying that is probably no where near correct.

Previous code I have used...

=
COUNT({$<JobType={"INB"},WaitTime={">0"}>} Account_Key)

Original

=COUNT({$<DiallerHangUp={1}>} Account_Key)

Only show records where a call has been abandoned.

=
 COUNT({$<DiallerHangUp={1},(COUNT({$<DiallerHangUp={1}>} Account_Key))={">0"}>} Account_Key)

Numeric Based Criteria

Miguel_Angel_Baeyens — Tue, 10 Nov 2009 23:46:15 GMT

If I'm not wrong, you want now to show all elements in a set that match ">0" (records where a call has been abandoned).

Then try

COUNT({$<DiallerHangUp = {">0"}>} Account_Key)

Numeric Based Criteria

johnw — Wed, 11 Nov 2009 01:42:35 GMT

What does your data look like? Are all of the fields mentioned on the same table? Do you have one row per call? One row per account with totals of the number of calls and wait time?

Numeric Based Criteria

Wed, 11 Nov 2009 21:23:21 GMT

Hi John,

I have 1 row of data per call and I am trying to summarise the job data.

My other experessions are the Job Start Time, Totals calls dialled in the job, the actual number of connects and the abandon amount.

Start Time =MIN(JobTime)

Calls Taken =

COUNT(Account_Key)

Connects =

COUNT({$<Calls_Worked={1}>} Account_Key)

Hang Ups =COUNT({$<DiallerHangUp = {">0"}>} Account_Key) (as per Miguels post)

Using the above formulas i am still seeing job data with 0 hangs. I know why but my attempts to re-write the formulas to something similar to Miguels example have failed.

Numeric Based Criteria

Wed, 11 Nov 2009 22:23:52 GMT

Hi,

My colleague at work was able to figure this out for me using a very similar syntax to Miguel.

Thanks for the help.