topic Re: How to count switch and first occurrences in QlikView

How to count switch and first occurrences

gabroteddy — Tue, 14 Apr 2020 14:05:42 GMT

Hi,

i have a table like this...with much more rows.

name	surname	dateofbirth	result	DATA VALIDAZIONE
PROVA	PROVA1	16/12/1938	POSITIVO	09/04/2020
PROVA	PROVA2	05/06/1941	POSITIVO	10/04/2020
PROVA	PROVA3	19/10/1930	POSITIVO	11/04/2020
PROVA	PROVA1	16/12/1938	POSITIVO	12/04/2020
PROVA	PROVA2	05/06/1941	NON RILEVATO	13/04/2020
PROVA	PROVA1	16/12/1938	NON RILEVATO	14/04/2020

In different dashboards i want calculate:

1) how many times a specific person (identified by nam+surname+dateofbith) have switched theri result (i.e. PROVA PROVA1 have switched once from POSITIVO to NON RILEVATO....)

2) count only the first occurence of a specific result for each person (i.e. PROVA PROVA1 have two result POSITIVO but i want count only the first)

Please help me.

Thx

Re: How to count switch and first occurrences

Saravanan_Desingh — Mon, 20 Apr 2020 01:09:41 GMT

Are you looking for this?

tab1: LOAD name, surname, dateofbirth, Count(DISTINCT result) As Count_Result Group By name, surname, dateofbirth ; LOAD * INLINE [ name, surname, dateofbirth, result, DATA VALIDAZIONE PROVA, PROVA1, 16/12/1938, POSITIVO, 09/04/2020 PROVA, PROVA2, 05/06/1941, POSITIVO, 10/04/2020 PROVA, PROVA3, 19/10/1930, POSITIVO, 11/04/2020 PROVA, PROVA1, 16/12/1938, POSITIVO, 12/04/2020 PROVA, PROVA2, 05/06/1941, NON RILEVATO, 13/04/2020 PROVA, PROVA1, 16/12/1938, NON RILEVATO, 14/04/2020 ];

Re: How to count switch and first occurrences

Brett_Bleess — Wed, 13 May 2020 20:17:13 GMT

If Saran's post got you what you needed, we would appreciate it if you would return to the thread and use the Accept as Solution button on their post to give them credit for the assistance and to let other Members know that worked. If you did something different, please consider posting what you did and then mark that post.

Regards,
Brett