Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
gr_eldred
Contributor II

does not filter the maximum date

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


fecha1.png

Can you help me please?

Tags (2)
1 Reply

Re: does not filter the maximum date

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)