topic Re: A Quick Script Question... in QlikView

A Quick Script Question...

Mon, 09 Jun 2014 14:35:43 GMT

Hi,

As part of my script load I have data with a start and end date(eg, Start-1st Jan 2014, End-1st Jan 2015). I'd like to load this record against all dates between these dates, so in Qlikview if I was to select June 2014 for example, this record would be included.

Is there a simple way to autogenerate the additional dates as part of the load script?

EG, Data looks like ABC, 01Jan2014, 01Jan2015.

I want to load into Qlikview...

ABC,01Jan2014

ABC,02Jan2014

ABC,03Jan2014

ETC....

ABC,31Dec2014

ABC,01Jan2015

Hope that makes sense and thanking your in advance.

Kind Regards,

Warren

Re: A Quick Script Question...

swuehl — Mon, 09 Jun 2014 14:39:58 GMT

Have a look at:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

Re: A Quick Script Question...

MK_QSL — Mon, 09 Jun 2014 14:42:49 GMT

Let vMinDate = NUM(Date('01/01/2014'));

Let vMaxDate = NUM(Date('01/01/2015'));

Load

Date(Date#(Date($(vMinDate) + IterNo() - 1),'DD/MM/YYYY'),'DDMMMYYYY') as Date

AutoGenerate 1

While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

Join

Load 'ABC' as Data AutoGenerate 1;

Re: A Quick Script Question...

Mon, 09 Jun 2014 15:07:48 GMT

Perfect - Thank you!

Re: A Quick Script Question...

Mon, 09 Jun 2014 15:07:49 GMT

Many thanks…

Re: A Quick Script Question...

MK_QSL — Mon, 09 Jun 2014 15:09:49 GMT

Kindly close the thread by selecting appropriate answer so that others can also use it...