topic Expression to count the last 120 days with makedate and other criteria in QlikView

Expression to count the last 120 days with makedate and other criteria

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

Hello Guys, I have the table below (Attached)

Cod_Agente	NomeAg	Uf	Dia	Mês	Ano	NuChassi
120	A	RS	1	12	2018	KDJDKCJDOLDJ12486
123	B	RS	2	10	2018	KDJDKCJDOLDJ12489
125	C	RS	3	8	2018	KDJDKCJDOLDJ12492
169	D	RS	4	6	2018	KDJDKCJDOLDJ12495
171,5	E	RS	5	4	2018	KDJDKCJDOLDJ12498
186,4	F	RS	6	2	2017	KDJDKCJDOLDJ12501
201,3	G	RS	7	9	2017	KDJDKCJDOLDJ12504
216,2	H	RS	8	7	2017	KDJDKCJDOLDJ12507

and I need to only count values greater than or equal to 120 days ago,

the problem is that I do not have a date field already created in the table,

I have to use the makedate function to create this field, but it is not working and I also

do not have access to create variables and / or create the field at the time of the script execution

(this is a read-only qvd file on the server)

Follows my failed expression:

COUNT({$<Uf={'RS'}, Date(Num(MakeDate (Ano, Mes, Dia)))>= Date(Num(Today()))-120)>}[NuChassi])

can you help me?

Re: Expression to count the last 120 days with makedate and other criteria

Anil_Babu_Samineni — Wed, 27 Jun 2018 01:15:05 GMT

I haven't see your date field in your table, perhaps this?

COUNT({$<Uf={'RS'} >} If(Date(Num(MakeDate (Ano, Mes, Dia)))>= Date(Num(Today()))-120)),[NuChassi])

Re: Expression to count the last 120 days with makedate and other criteria

rafaeloneil — Wed, 27 Jun 2018 15:37:29 GMT

Really did not work the suggested expression, I inserted the table but I do not know why it is not visible in the post, it continues in the image format