30 Days back

[pgalvezt]

Hello,

I have created an app that load multiples textfiles called Comparision_01-08-2014,Comparision_02-08-2014 and so on. These textfile are create everyday with Comparision_date.

Here is my load script. The load is fine.

Comparacion_Provision:

LOAD

*,

FROM [Datos\Comparacion_Provision_*.txt] (ansi, txt, delimiter is ';', embedded labels, msq);

I would like to obtain 30 days ago when I have select 12-08-2014. So I would like to show 12-07-2014 Until 11-08-2014.

How could obtain this in Qlikview,

Thanks!

[ecolomer]

Y si calculas primero a partir de la fecha del día ... Today()   la fecha límite .... Today() - 30   que será el sufijo que llevará el fichero último?

Podrías crear un bucle desde esa fecha hasta hoy sumando un dia cada vez ¿ok?

Perdona que te escriba en español

[jagan · Accepted solution]

Hi,

Try like this

=Sum({<DateDimensionName={'>=$(=Date(Max(DateDimensionName) - 31))<=$(=Date(Max(DateDimensionName) - 1))'}>} MeasureName)

Note : Replace DateDimensionName and MeasureName with your actual Date and Measure field names.  Also make sure Date in DateDimensionName field and Today() date format should be same.

Hope this helps you.

Regards,

Jagan.