does not filter the maximum date

gr_eldred — Thu, 23 Nov 2017 18:22:34 GMT

I have a problem with a date filter, you are not paying attention to this filter.

already try with a date (date # (max (Fecha_Fin_Semana)))

Fecha_Fin_Semana ={"=$(=Max({1}Fecha_Fin_Semana))"}

The full expression is this

max({$<Clasificación={'Mac'}, Fecha_Fin_Semana ={"=$(=Max({1}Fecha_Fin_Semana))"}, Pto_vta-={'CEDIS','Compudabo Coacalco','Compudabo Coacalco CosmoPol','CompuDabo Nápoles','CompuDabo Polanco','CompuDabo Portales','CompuDabo Rojo Gomez','Compudabo Santa Fé','Programas de Lealtad','Ventas Corporativas','Venta Empleados', 'Service Center Santa Fe'}>}Cant6W)

my column comes if from script

date#(Fecha_Fin_Semana,'DD/MM/YYYY') as Fecha_Fin_Semana

Can you help me please?

Re: does not filter the maximum date

rubenmarin — Thu, 23 Nov 2017 18:30:24 GMT

Hi Eldred, maybe it's because of date formats, can you try with?:

max({$<Clasificación={'Mac'}, Fecha_Fin_Semana={"$(=Date(Max({1}Fecha_Fin_Semana), ‘DD/MM/YYYY’))"}, Pto_vta-={'CEDIS','Compudabo Coacalco','Compudabo Coacalco CosmoPol','CompuDabo Nápoles','CompuDabo Polanco','CompuDabo Portales','CompuDabo Rojo Gomez','Compudabo Santa Fé','Programas de Lealtad','Ventas Corporativas','Venta Empleados', 'Service Center Santa Fe'}>}Cant6W)

topic Re: does not filter the maximum date in QlikView

does not filter the maximum date

Re: does not filter the maximum date