topic Re: problems filtering date in QlikView

problems filtering date

gr_eldred — Tue, 21 Nov 2017 21:36:01 GMT

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

Re: problems filtering date

gr_eldred — Tue, 21 Nov 2017 23:41:18 GMT

Can anybody help me??

Re: problems filtering date

settu_periasamy — Wed, 22 Nov 2017 04:57:52 GMT

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?

Re: problems filtering date

jonathandienst — Wed, 22 Nov 2017 05:16:48 GMT

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,

...

Re: problems filtering date

gr_eldred — Thu, 23 Nov 2017 03:15:11 GMT

it did not work