topic Re: Count If / Aggr Issue in QlikView

Count If / Aggr Issue

Tue, 09 Jul 2013 05:53:52 GMT

Hi All,

I have a table with unique employee id and count of cases in front of them.

ManagerId Emp ID Cases

A 1 5

A 2 10

A 3 5

A 4 20

A 5 5

And i want to create the following :

ManagerID Count of EMPID with Count of Cases =3

A 3

I want to

Please help me out with the same...

Regards,

Utsav

lironbaram — Tue, 09 Jul 2013 06:19:11 GMT

hi it wasn't clear what you realy wanted but

you need to use something like

sum(aGGR(IF(SUM(Cases)=5,1,0),EmployeeID))

Tue, 09 Jul 2013 06:39:11 GMT

see ttachein straight--

dimension- Emp ID

expression- count(TOTAL DISTINCT Cases)

then output like this

see attachement

Tue, 09 Jul 2013 06:40:35 GMT

Hi utsav,

T think i get u, u want to develope report which counts cases for each manager.

right

in that case u need to use pivot table .

and add dimension manager id,cases & in expression side add exp like

=sum(Emp ID)

Tue, 09 Jul 2013 07:02:12 GMT

Hi All,

the expression to count the cases is as follows :

=Count(Distinct{$<TableFlag={Abc},Channel={'Bank'},Date={$(=vYesterday)},Year= ,Quarter= ,Month= >}Cases))

As the Cases Columns is a calculated expression I am unable to use it in a set analysis form.

regards,

Utsav