Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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!