topic Genrating dynamic date in QlikView

Genrating dynamic date

Tue, 13 Apr 2010 14:19:50 GMT

Hi all,

I have to generate some dynamic values in a table. For the moment the code is like that.

CAL:
LOAD * INLINE [
lib_date, VALDate
ADH_M0, 01/12/2009
ADH_M1, 01/11/2009
ADH_M2, 01/10/2009
ADH_M3, 01/09/2009
ADH_M4, 01/08/2009
ADH_M5, 01/07/2009
ADH_M6, 01/06/2009
ADH_M7, 01/05/2009
ADH_M8, 01/04/2009
ADH_M9, 01/03/2009
ADH_M10, 01/02/2009
ADH_M11, 01/01/2009
ADH_M12, 01/12/2008
];

Best regards

Gilles

I want to generate some alternative code to obtain for each load (the application will be load every month) the last 13 months. Can you help me ?

Genrating dynamic date

justinasp — Tue, 13 Apr 2010 14:42:31 GMT

Hi, Remy,

try something like this

FOR i=0 TO 12
LOAD 'ADM_M'&$(i) as lib_date, ADDMONTHS(MONTHSTART(TODAY()),-$(i)) as VALDate INLINE
[
var1, var2
$(lib_date), $(VALDate)
];
NEXT

Cheers,

Justinas

Re. :Re: Genrating dynamic date

Tue, 13 Apr 2010 14:51:10 GMT

Hi Justinas,

I got this error message

Erreur de syntaxe, FROM manquant ou mal placé :
LOAD 'ADM_M'&0 as lib_date,
ADDMONTHS(MONTHSTART(TODAY()),-0) as VALDate
INLINE[var1, var2, ]
LOAD 'ADM_M'&0 as lib_date,
ADDMONTHS(MONTHSTART(TODAY()),-0) as VALDate
INLINE[var1, var2, ]

regards

Gilles

Re. :Re: Genrating dynamic date

justinasp — Tue, 13 Apr 2010 15:00:54 GMT

The problem could be if you copied the script. Rewrite code as you see in my message. If you still have an error I'll attach a file.

Good luck

Genrating dynamic date

Tue, 13 Apr 2010 15:03:56 GMT

hi Remy,

try this:

LOAD 'ADM_M'& (rowno()-1) as lib_date,

ADDMONTHS(MONTHSTART(TODAY()),(1-rowno())) as VALDate

autogenerate 13;

Alex

Re. :Re: Genrating dynamic date

Tue, 13 Apr 2010 15:48:47 GMT

Hi Justinas,

It works

Thanks a lot for your help

Regards

Gilles

Re. :Re: Genrating dynamic date

Tue, 13 Apr 2010 15:53:14 GMT

Hi Alex,

Thanks for your help. It works.

Best regards

Gilles