Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
gr_eldred
Contributor II

problems filtering date

Good afternoon, I intend to use the Fecha_Fin_Semana field as a filter in the following way.

Fecha_Fin_Semana ={"<=$(=Max(Fecha_Fin_Semana)-4)"}


The expression is the following:

aggr(rank(num(AVG({$<Clasificación={'iPad'}, Fecha_Fin_Semana ={"<=$(=Max(Fecha_Fin_Semana)-4)"}>}Cant6W)),1),Pto_vta)

My problem is that you are not subtracting the days that I need to this date and try to date(), but even so it is not taking away the two days that I need.

Can you help me ?, I attach an image of the field

fecha1.png

4 Replies
gr_eldred
Contributor II

Re: problems filtering date

Can anybody help me??

Re: problems filtering date

Hi,

Can you put this below into separate textbox and check, is that giving the expected date?

=Date(Max(Fecha_Fin_Semana)-4))


Can you provide the sample, if it is not working for you?

MVP
MVP

Re: problems filtering date

Looks like that date field may be a string, not a date value. Convert it to a date during the load and try again:

LOAD

    ...

    Date#(Fecha_Fin_Semana, 'dd/MM/yyyy') as Fecha_Fin_Semana,

    ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
gr_eldred
Contributor II

Re: problems filtering date

it did not work