topic Re: addmonths and iterno function. in QlikView

addmonths and iterno function.

Tue, 16 Jun 2015 06:43:39 GMT

Hi ,

my requirement is , when i select a particular date in datefield column, i need to generate a new column called pastdate having past 12 month's(MM) dates for the same DD.

right now, i am only able to generate 12 values, i need output of pastdate like this;

if i select 01-01-2015 (DD-MM-YYYY) from datefield then i should be able to generate 12 values in 'i' like this

01-12-2014

01-11-2014

01-10-2014

01-01-2014.

and i need to do it at script level only.

thanks.

Re: addmonths and iterno function.

Peter_Cammaert — Tue, 16 Jun 2015 06:46:21 GMT

Create an intermediate table between data and master calendar that is called "ASOF"-table.

Search the community: there are many threads discussing this kind of table.

Good luck,

Peter

Re: addmonths and iterno function.

Tue, 16 Jun 2015 06:49:38 GMT

Hi peter , isnt it possible just by writing a script using addmonths function ?

Re: addmonths and iterno function.

Peter_Cammaert — Tue, 16 Jun 2015 06:55:28 GMT

Yes, that is the basic technique to create an ASOF-table.

Peter