Adding in set analysis

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

Here is the issue.

I am trying to figure out how many times during an hour a call was placed by a person. If 5 calls or less was made in hour 8, then give give a result of 0, if more than 5 then give me a result of 1. However I need it to be able to add based on different days.

For example.

01/01/2018 at 8 the person made 4 calls

01/02/2018 at 8 the person made 6 calls

01/03/2018 at 8 the person made 9 calls

01/04/2018 at 8 the person made 1 calls

01/05/2018 at 8 the person made 10 calls

For my pivot table I have the following set analysis

(If(Count({<CallTimeHOUR = {6}>} CallTime)< 5,0,1)

When I look at it for the day, it works, however when looking at it for the week it does not.

The result for each day would be

01/01/2018 - 0

01/02/2018 - 1

01/03/2018 - 1

01/04/2018 - 0

01/05/2018 - 1

But when I group the pivot table by the week, I would just get the result of 1, but I am looking for the result of 3.

What am I doing wrong.

Thanks in Advance!!

Re: Adding in set analysis

Anil_Babu_Samineni — Fri, 12 Jan 2018 13:43:34 GMT

Can you please share Sample? May be try this?

(If(Count(TOTAL <Week> {<CallTimeHOUR = {6}>} CallTime)< 5,0,1)

Re: Adding in set analysis

sunny_talwar — Fri, 12 Jan 2018 13:52:29 GMT

Try this

Sum(Aggr(If(Count({<CallTimeHOUR = {6}>} CallTime)< 5,0,1), Date))

topic Re: Adding in set analysis in QlikView

Adding in set analysis

Re: Adding in set analysis

Re: Adding in set analysis