Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

30 Days back

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!

1 Solution

Accepted Solutions
jagan
MVP & Luminary
MVP & Luminary

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.

View solution in original post

2 Replies
ecolomer
Master II
Master II

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
MVP & Luminary
MVP & Luminary

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.

View solution in original post