topic Re: count items in subset in QlikView

count items in subset

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

I need to count the different items in a data subset in a data array like the following:

ID	Tipo	Amount
1	Daño Total	$3.00
2	Daño parcial	$5.00
3	Daño elevado	$1.00
4	Daño elevado	$7.00
5	Daño Total	$10.00
6	Daño Total	$3.50

The answer I would expect is as follows:

Tipo	claims	Amount
Daño total	3	$16.50
Daño Parcial	1	$5.00
Daño elevado	2	$8.00

=count (distinct tipo) will give me 3

Can you help me please with the formula for COUNTING the claims at each sub set of TIPO ?

thanks

Re: count items in subset

trdandamudi — Fri, 01 Dec 2017 19:30:30 GMT

Is this what you are looking for ?

Data:
Load * Inline [
ID,Tipo,Amount
1, Daño Total, $3.00
2, Daño parcial, $5.00
3, Daño elevado, $1.00
4, Daño elevado, $7.00
5, Daño Total, $10.00
6, Daño Total, $3.50
];

Re: count items in subset

vishsaggi — Fri, 01 Dec 2017 19:33:06 GMT

Just use Count(Tipo)