How can I filter a KPI using a date?

Skylia — Fri, 10 Jun 2022 17:30:36 GMT

Hello everyone!

I need your help 🙂 I have to make a KPI with these rules:

(1) I have to count a number of records when the column is "Yes" for the last 12 months of a date field ( date + 30 calendar days). Note: I must add 30 calendar days to this date field.

(2) I have to count only the records that have breached the field [date + 30 calendar days], this is compared with Today(). So I would get the unfulfilled

(3) Obtain the final calculation: (1 / 2) %

I stayed here

Count({<[COL1]={"Y"}>}[N_Register]

Year([DatePas]+30)-1

EXTRA: How can I add calendar days to a date?

Re: How can I filter a KPI using a date?

Skylia — Fri, 10 Jun 2022 19:14:37 GMT

I do it!

num(Count({<[AÑOMAXIMO]={">=$(vMinAñoFechaMaxA)<=$(vMaxAñoFechaMaxAtencionA)"},[Presentacion recurso de reconsideracion]={"SI"},[FechaMaxima]={"<05/05/2021"}>}[N_REGISTRO_MODULO])
/Count({<[AÑOMAXIMO]={">=$(vMinAñoFechaMaxA)<=$(vMaxAñoFechaMaxAtencionA)"},[Presentacion recurso de reconsideracion]={"SI"}>}[N_REGISTRO_MODULO]),'#,##0%')

topic Re: How can I filter a KPI using a date? in QlikView

How can I filter a KPI using a date?

Re: How can I filter a KPI using a date?