Count with conditions

Frquiroga1995 — Sat, 16 Nov 2024 17:33:26 GMT

Hi !

I loaded a lot of data in the script. After that, I want to visualize some information in the front.

I want to count the amount of "Nro Interno" related to the date "Fecha Recep"

And also, the amount of "Nro Interno" related to the date "Fecha Cambio" with "Descrip" = Aprobado.

Fecha Recep and Fecha Cambio are two different dates, and for different purposes.

The thing is that in the front I want to have just one filter for date in a list box (a general date). And with that filter, be able to have the counts I mentioned before. That date must apply for Fecha Recep and Fecha Cambio.

Nro Interno	Fecha Recep	Fecha Cambio	Descrip
12	10/01/2021	10/01/2021	Aprobado
43	12/09/2020	10/01/2021	Aprobado
34	10/07/2020	25/12/2020	Pendiente
54	11/06/2020	10/01/2021	Aprobado

I hope I made myself understand

Thanks in advance !

Re: Count with conditions

QFabian — Thu, 28 Jan 2021 22:14:55 GMT

Hi @Frquiroga1995 , please check the example qvw.

It creates a new field, based on your fields :

Fecha:
Load distinct [Fecha Recep] as Fecha Resident Datos;
Load distinct [Fecha Cambio] as Fecha Resident Datos;

And then, you can use this expression :

count({< [Fecha Cambio] = p(Fecha), Descrip = {"Aprobado"} >} [Nro Interno])

See the attached file, saludos!

topic Count with conditions in QlikView

Count with conditions

Re: Count with conditions