topic 30 Days back in QlikView

30 Days back

pgalvezt — Tue, 12 Aug 2014 19:53:10 GMT

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!

Re: 30 Days back

ecolomer — Tue, 12 Aug 2014 22:02:35 GMT

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

Re: 30 Days back

jagan — Wed, 13 Aug 2014 03:10:01 GMT

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.