topic Re: Autogenerate in QlikView

Autogenerate

mendoncart — Tue, 21 Jan 2014 14:20:51 GMT

Hey guys.

I'm having some trouble with this function.

The thing is that i have a budget table that the records are made by start and end date.

So, it's like this:

Product Start Date End Date Value

Product A 201301 201307 1000

and i would like to make a table like this:

Product Date Value

Product A 201301 1000

Product A 201302 1000

Product A 201303 1000

Product A 201304 1000

Product A 201305 1000

Product A 201306 1000

Product A 201307 1000

I know that autogenerate probably will do the trick but i just don't know how to do it.

So, can anyone help me out?

PS: Did i posted in the right place?

Thanks

Re: Autogenerate

maxgro — Tue, 21 Jan 2014 14:29:31 GMT

see this very good post

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

Re: Autogenerate

Anonymous — Tue, 21 Jan 2014 14:31:41 GMT

Looping works. Something like this:

LOAD

Product,

Value,

StartDate + iterno() - 1 as Date

Resident Temp

while StartDate + iterno() - 1 <= EndDate ;

Re: Autogenerate

Tue, 21 Jan 2014 14:35:18 GMT

Try like below:

LOAD Product ,

Value,

[Start Date] + IterNo() -1 AS Date

FROM SOURCETABLE

While [Start Date] + IterNo() -1 <= [End Date];

Please find the attached qvw as reference.

Re: Autogenerate

jagan — Tue, 21 Jan 2014 15:46:50 GMT

Hi,

Try like this

TABLE:

LOAD Product ,

Value,

Date(MonthStart(StartDate, IterNo() -1), 'YYYYMM') AS Date

While Date(MonthStart(StartDate, IterNo() -1), 'YYYYMM') <= EndDate;

LOAD Product,

Date(Date#([Start Date], 'YYYYMM')) AS StartDate,

Date(Date#([End Date], 'YYYYMM')) AS EndDate,

Value

Inline [

Product, Start Date, End Date, Value

Product A , 201301, 201307, 1000];

Regards,

Jagan.